depends what you mean by numeric. SELECT * FROM Table WHERE isnumeric(varcharfield) = 1 will allow through things like 1e2 which can be converted to a numeric datatype.
You might want where patindex('%[^0-9]%',varcharfield) = 0 which will give those which have only numeric digits.
========================================== Cursors are useful if you don't know sql. DTS can be used in a similar way. Beer is not cold and it isn't fizzy.
Thanks for your reply...What I want to do is...convert a nvarchar field to numeric...so I want to see which records contain numeric values to correct the ones that are not... I couln't do it yet...I keep getting this: - Unable to modify table. ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type nvarchar to numeric.
seems to be a problem with Null and blank ocurrences...
isnumeric() function
Posted - 01/06/2006 : 08:58:38
