sql server - 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 != ''