How to get only numeric column values?

user_128071 0
Viewed 170208

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

sql-server
5 Answers
SELECT column1 FROM table WHERE column1 not like '%[0-9]%'

Removing the '^' did it for me. I'm looking at a varchar field and when I included the ^ it excluded all of my non-numerics which is exactly what I didn't want. So, by removing ^ I only got non-numeric values back.

user_56397790
Related