SQL Server/T-SQL Tutorial/Math Functions/ISNUMERIC

SELECT ISNUMERIC("123")

5> SELECT ISNUMERIC("123")
6> GO
-----------
          1
(1 rows affected)

SELECT ISNUMERIC("123ABC")

3>
4> SELECT ISNUMERIC("123ABC")
5> GO
-----------
          0
(1 rows affected)

select ISNUMERIC(-1.25)

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>