Loading lesson path
Concept visual
Start at both ends
Tests whether the expression is numeric:
SELECT ISNUMERIC(4567);The ISNUMERIC() function tests whether an expression is numeric. This function returns 1 if the expression is numeric, otherwise it returns 0.
expression )
Required. The value to test
SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse
Tests whether the expression is numeric:
SELECT ISNUMERIC('4567');Tests whether the expression is numeric:
SELECT ISNUMERIC('Hello world!');Tests whether the expression is numeric:
SELECT ISNUMERIC(20*3);Tests whether the expression is numeric:
SELECT ISNUMERIC('2017-08-25');❮ SQL Server Functions