ISNUMERIC
ISNUMERIC( expression )
Section titled “ISNUMERIC( expression )”- expression: A valid SQL Server expression that is able to return a single unit of data like a string. This specific parameter becomes the target for the ISNUMERIC function to evaluate whether it can be converted to a numeric data type or not.
Example
Section titled “Example”DECLARE @TestValue VARCHAR(10) = '12345';SELECT ISNUMERIC(@TestValue) AS Is_Numeric;Output
Section titled “Output”Is_Numeric----------1Explanation
Section titled “Explanation”ISNUMERIC returns 1 when the input can be converted to one of the numeric data types. In this example, it tests whether the value ‘12345’ is numeric, and returns 1, indicating that it is numeric.