SQL Server Transact Basic to Expert - Check if a given value is numeric or not using SQL

Karthikeyan Anbarasan
12y
5.1k
0
0

Blog

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