ISNUMERIC basic

by Ivan Gerasimenko

JavaScript

DECLARE @test AS TABLE
(
	[Val] NVARCHAR(255)
);


INSERT INTO @test VALUES ('123');
INSERT INTO @test VALUES ('123.456');
INSERT INTO @test VALUES ('123,456');
INSERT INTO @test VALUES ('2014.10.21');
INSERT INTO @test VALUES ('0xAB');
INSERT INTO @test VALUES ('');


SELECT 
	[Val]
	,[isNumeric] = ISNUMERIC(Val)
FROM @test tb;