Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Register
Login
SQL Server Transact Basic to Expert - Check if a given value is numeric or not using SQL
Karthikeyan Anbarasan
Aug 17, 2012
3.7
k
0
0
Blogs
WhatsApp
SQL Server Transact Basic to Expert - Check if a given value is numeric or not using SQL
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
Next Recommended Reading
SQL Server Transact Basic to Expert - Decreasing a date value to 4 months using SQL query