Home Forums SQL Server 7,2000 General IsNumeric RE: IsNumeric
SwePeso
SSC-Dedicated
Points: 39752
More actions
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"