How to check whether the field value is a number in SQL Server

Recently, a project needs to check whether the value of a certain numeric field is a number. Because the data rows are massive, it is necessary to use SQL statements for screening. Here is a memo.

The function used is IsNumeric. The specific statement is as follows:
Copy codeThe Code is as follows:
SELECT *
FROM table
WHERE IsNumeric (field name to be checked) = 0

ISNUMERIC

Determine whether the expression is a valid numeric type.

Syntax
ISNUMERIC (expression)

Parameters
Expression

The expression to be calculated.

Return type
Int

Note
If the number of input expressions is a valid integer, floating point number, money, or decimal type, ISNUMERIC returns 1; otherwise, 0. If the return value is 1, the expression can be converted to one of the preceding numeric types.