SQL ISNUMERIC is an inbuilt function that is used to check whether the expression passed as an input is the valid number or not. The ISNUMERIC() function returns 1 if the expression is a valid number. Otherwise, it returns 0.
SQL ISNUMERIC
SQL ISNUMERIC function tests whether the expression is numeric. The ISNUMERIC() function accepts an expression and returns 1 if the expression is a valid numeric type; otherwise, it returns 0.
Syntax
ISNUMERIC (Expression);
Parameters
Expression: The expression is to be checked, whether it is a valid number or not.
The function checks whether the expression entered can be converted to a numeric datatype or not.
Note that a valid numeric type is one of the following:
Exact numbers: BIGINT, INT, SMALLINT, TINYINT, and BIT
Fixed precision: DECIMAL, NUMERIC
Approximate: FLOAT, REAL
Monetary values: MONEY, SMALLMONEY
Query 1
SELECT ISNUMERIC (9876);
Output
1
Explanation
The expression entered is already in the numeric form. So, the function returned 1 as an output.
Query 2
SELECT ISNUMERIC (‘9876’);
Output
1
Explanation
The expression was in string format, which, when converted implicitly to numeric form, returned a valid number. So, the function returned 1 as an output.
Query 3
SELECT ISNUMERIC (10*5);
Output
1
Explanation
The arithmetic expression, when executed, returned a valid number. Thus, the function returned 1 as an output.
Query 4
SELECT ISNUMERIC (‘AppDividend.Com’);
Output
0
Explanation
The expression was in string format, which, when tried to be converted implicitly to numeric form, didn’t return a valid number. So, the function returned 0 as an output.
Query 5
SELECT ISNUMERIC (‘2020-02-28’);
Output
0
Explanation
The expression was in datetime format, which cannot be converted to numeric form. So, the function returned 0 as an output.
Finally, SQL ISNUMERIC Function Example is over.
