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)
Uploading...

---

---

Home