My Learnings
Friday, January 31, 2020
Get only numeric column values SQL
SELECT column1 FROM table WHERE ISNUMERIC(column1) = 1
OR
SELECT column1 FROM table WHERE column1 not like '%[^0-9]%' and column1 != ''
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment