Method for checking whether a field's value is a number in SQL Server _mssql

Recently there is a project that needs to check whether a character field value is a number, because the data row is massive, so need to pass through the SQL statement to screen, here to make a memo.

The function used is isnumeric, and the concrete statement looks like this:

Copy Code code as follows:

SELECT *
From table
WHERE isnumeric (field name to check) = 0

IsNumeric

Determines whether an expression is a valid numeric type.

Grammar
IsNumeric (expression)

Parameters
Expression

The expression to evaluate.

return type
Int

Comments
When the input expression is counted as a valid integer, floating-point number, money, or decimal type, the IsNumeric returns 1, otherwise it returns 0. A return value of 1 ensures that expression can be converted to one of the above numeric types.