|
This blog shows how to check if the given value is Numeric or not using the ISNUMERIC keyword in SQL query Example: SELECT ISNUMERIC('1Ab3v') The expected result would be 0 which means its not numeric if a valid number is given it would return as 1 |
SQL Server Transact Basic to Expert - Check if a given value is numeric or not using SQL
1 Comment
Join the conversation! Your thoughts help the community grow.
Sign in to leave a comment
It is the same account you read, post and publish with — and you will come straight back to this page.
waqas memonPosted Aug 17, 2012, 4:37 PM
hi also try for fetch number from alpha numeric...http://codingresolved.com/discussion/70/find-numeric-value-in-string-in-sql-server-2005#Item_2