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

SELECT ISNUMERIC("123")

   <source lang="sql">

5> SELECT ISNUMERIC("123") 6> GO

---

         1

(1 rows affected)</source>

SELECT ISNUMERIC("123ABC")

   <source lang="sql">

3> 4> SELECT ISNUMERIC("123ABC") 5> GO

---

         0

(1 rows affected)</source>

select ISNUMERIC(-1.25)

   <source lang="sql">

4> select ISNUMERIC(-1.25) 5> GO

---

         1

(1 rows affected)</source>

select ISNUMERIC("2001-09-30")

   <source lang="sql">

3> select ISNUMERIC("2001-09-30") 4> GO

---

         0

(1 rows affected) 1></source>

select ISNUMERIC("SQL Server")

   <source lang="sql">

2> select ISNUMERIC("SQL Server") 3> 4> GO

---

         0

(1 rows affected) 1></source>