Determines if the expression is numeric.
| SELECT ISNUMERIC(4567); |
The ISNUMERIC() function checks if an expression is numeric and returns 1 if true, otherwise 0.
| ISNUMERIC(expression) |
|
Parameter |
Description |
|
expression |
Mandatory. The value that is checked to determine if it is numeric. |
|
Works in: |
SQL Server (from 2008 onward), Azure SQL Database, Azure SQL Data Warehouse, and Parallel Data Warehouse |
Checks if the expression qualifies as numeric.
| Checks if the expression qualifies as numeric. |
Determines if the expression is numeric.
| SELECT ISNUMERIC(‘Hello world!’); |
Checks if the expression is of a numeric nature.
| SELECT ISNUMERIC(20*3); |
Determines if the expression can be classified as numeric.
| SELECT ISNUMERIC(‘2017-08-25’); |