Is there an sql condition that can look for non integers in a column?

Question

Basically I would like a select statement that would function like this

SELECT * FROM table   WHERE column IS NOT INT   

Is there a condition like this or how do you check for non-integers in an nvarchar(10) column?

Answer 1

In SQL Server you can do:

SELECT  * FROM    mytable   WHERE   CASE WHEN IsNumeric(mycolumn) = 1 THEN CASE WHEN CAST(mycolumn AS FLOAT) <> CAST(CAST(mycolumn AS FLOAT) AS INT) THEN 1 END ELSE 1 END = 1 

Answer 2

You could also use

SELECT  * FROM    T  WHERE  C = ''         OR C LIKE '%[^0-9-]%' /*Contains a char other than - or 0-9*/         OR C LIKE '_%-%'  /*Contains the - char other than 1st position*/