Sorguda gelen değer numerik mi değil mi?

http://stackoverflow.com/questions/6345687/select-from-col-where-name-null-name-is-an-int-sql-problem

SELECT * FROM col WHERE NOT name IS NOT NULL AND name NOT LIKE '%[^0-9]%'

SELECT * FROM col WHERE NOT name IS NOT NULL AND ISNUMERIC(name) = 1

For SQL server this is the Syntax:

SELECT * FROM col WHERE NOT name IS NULL AND ISNUMERIC(name) = 1 AND NOT name LIKE '%.%'


If you use MSSQL, SELECT * FROM col WHERE name <> 'NULL' AND IsNumeric(name) = 1