Using the IsNumeric Function within a Query

[jmgibson]

I have a column that I need to sum and present on a page. Unfortunately, the values within the column are stored as text data. I figured I could utilize the "isNumeric" function here, but it doesn't seem to work. Is there a better way to handle summing text data (that are all numbers)within a query?

SELECT tbl_LD_Data.datex, sum(isnumeric(tbl_LD_Data.Timex))as TimeSum [/color red]
FROM tbl_LD_Data, tbl_LD_Dates

 

[r937]

what database is this? sybase? db2? postgresql? firebird? oracle? access?

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts March 6 2005)

 

[jmgibson]

It's an Access database.

 

[r937]

select tbl_LD_Data.datex
, sum(
iif(isnumeric(tbl_LD_Data.Timex)
,tbl_LD_Data.Timex
,0)
) as TimeSum
from ...

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts March 6 2005)