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






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

-----------
          1

(1 rows affected)








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')