Posted by Jayce Ooi as Programming
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′.
DECLARE @temp nvarchar(100);
SELECT @temp = ’100′;
The returned result is ’1′.