SQL Server ISNUMERIC() Function

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.

ISNUMERIC( expression)

Parameter	Description
expression	Required. The value to test

Works in:	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');