Example
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 |
|---|