Example
Tests whether the expression is numeric:
SELECT ISNUMERIC(4567);
Definition and Usage
The ISNUMERIC() function tests whether an expression is numeric.
This function returns 1 if the expression is numeric, otherwise it returns 0.
Syntax
ISNUMERIC(expression)
Parameter Values
| Parameter | Description |
|---|---|
| expression | Required. The value to test |
Technical Details
| Works in: | SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse |
|---|
More Examples
Example
Tests whether the expression is numeric:
SELECT ISNUMERIC('4567');
Example
Tests whether the expression is numeric:
SELECT ISNUMERIC('Hello world!');
Example
Tests whether the expression is numeric:
SELECT ISNUMERIC(20*3);
Example
Tests whether the expression is numeric:
SELECT ISNUMERIC('2017-08-25');