T-SQL Tutorial

T-SQL ISNUMERIC System Function


Check if an expression is a valid numeric type. Return 1 for valid numeric type and 0 for invalid numeric type.

ISNUMERIC Syntax:

ISNUMERIC(expression)

ISNUMERIC Example:

SELECT ISNUMERIC('abc') as col_1,
ISNUMERIC('01/28/2014') as col_2,
ISNUMERIC(123) as col_3,
ISNUMERIC(null) as col_4,
ISNUMERIC(-1) as col_5,
ISNUMERIC(0.8) as col_6;

col_1col_2col_3col_4col_5col_6
001011

See also: T-SQL Functions -> COALESCE | HOST_ID | HOST_NAME | ISNULL | NULLIF