Home
Transact SQL IsNumeric Examples
select
iif(isnumeric('123') = 1, 'It''s numeric', 'It''s not mumeric') as ShouldBeNumeric
select
iif(isnumeric('12a') = 1, 'It''s numeric', 'It''s not mumeric') as OugthNotBeANumber
select
iif(isnumeric('123') = 0, 'It''s numeric', 'It''s not mumeric') as OugthNotBeANumber
select
iif(isnumeric('12a') = 0, 'It''s numeric', 'It''s not mumeric') as ShouldBeNumeric
Reader's Comments
Name
Comment
Add a RELEVANT link (not required)
Upload an image (not required)
Uploading...
Home