Check for Numeric Value using SQL Server 2000
numeric, sql-server, sql-server-2000
Solution
IsNumeric() function returns 1 for strings (varchars) which can be converted to a number and 0 for those that cannot..
Check out IsNumeric function
Problem
How can I know if a VARCHAR field's value can be successfully converted to an integer? I want to do it massively to insert records from one table to another...