T-SQL query where column only contains numbers.

Question

Possible Duplicate:
How to get only numeric column values?

I am trying to write a T-SQL query that only returns rows where a specific column only contains numbers.

something like

select * from table where column like '[0-9]%'

The problem is the column can be 1 - 10 characters long.

Answer 1

SELECT *
FROM yourTable
WHERE yourColumn NOT LIKE '%[^0-9]%'

Answer 2

Use the IsNumeric function:

select * from table where IsNumeric(column) = 1