SQL Server/T-SQL/Math Functions/ISNUMERIC

select ISNUMERIC(-1.25)

 

3>
4> select ISNUMERIC(-1.25)
5> GO
-----------
          1
(1 rows affected)

select ISNUMERIC("2001-09-30")

 
3> select ISNUMERIC("2001-09-30")
4> GO
-----------
          0
(1 rows affected)
1>

select ISNUMERIC("SQL Server")

 
2> select ISNUMERIC("SQL Server")
3>
4> GO
-----------
          0
(1 rows affected)
1>