How to get only numeric column values?

Question

Using SQL Server 2005

I want to get only numeric values from the table

Column1

12345 asdf 2312 ase acd ..., 

Tried Query

Select Isnumeric(column1) from table 

Showing Result as

1 0 1 0 0 .., 

I need the colum1 numeric value

Need SQL Server Query help

Answer 1

SELECT column1 FROM table WHERE ISNUMERIC(column1) = 1 

Note, as Damien_The_Unbeliever has pointed out, this will include any valid numeric type.

To filter out columns containing non-digit characters (and empty strings), you could use

SELECT column1 FROM table WHERE column1 not like '%[^0-9]%' and column1 != ''