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

Post Your Comment Posts/Links Rules

Name

Comment

Add a RELEVANT link (not required)

Upload an image (not required)

No uploaded image
Real person number
Please enter the above number below




Home
Admin Ren's Biking Blog