select ISNUMERIC('SQL Server') : ISNUMERIC « Math Functions « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. Math Functions
  3. ISNUMERIC
2> select ISNUMERIC('SQL Server')
3>
4> GO

-----------
          0

(1 rows affected)
1>








11.11.ISNUMERIC
11.11.1.select ISNUMERIC(-1.25)
11.11.2.select ISNUMERIC('SQL Server')
11.11.3.select ISNUMERIC('2001-09-30')
11.11.4.SELECT ISNUMERIC('123ABC')
11.11.5.SELECT ISNUMERIC('123')