>>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
>
Yes, it's all non-numeric. I was looking for an isdigit() and it seems you have given it to me!
Thanks once again!
John Harvey
Shelbynet.com
"I'm addicted to placebos. I could quit, but it wouldn't matter." Stephen Wright