Home Forums SQL Server 7,2000 General IsNumeric RE: IsNumeric

  • March 26, 2008 at 2:33 am

    #793889

    If only digits are allowed, try this

    SELECT*

    FROMTable1

    WHERECol1 NOT LIKE '%[^0-9]%'

    N 56°04'39.16"
    E 12°55'05.25"