>I thought the following code would work, but it doesn't. Maybe one of you SQL gurus can help. I have a sql table which has a column for badge number (badgeno) it is of type char() 4 characters. I attempted to run a query from vfp like the following:
>
>select * from employees where cast(badgeno as numeric(10))>0
>
>I get an error message - Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type varchar to numeric
>
>Any ideas?
Most likely you have none-numeric data. Run following query to find offending record(s)
select * from employees where ISNUMERIC((badgeno) = 0
--sb--