What is ISNUMERIC in Transact-SQL? It is used to determine that the value is numeric or not. It will return ‘1′ when the value is numeric. Else it will return ‘0′.

Example,

DECLARE @temp nvarchar(100);
SELECT @temp = ‘100′;
SELECT ISNUMERIC(@temp);

The returned result is ‘1′.

Tags: Transact-SQL