How to fetch the number / strings alone

I would like to fetch the number/Strings alone which is having the varchar data in the column...

Lets take an example.., The column is being looks like below;

Column
abcd
edfd
123
321
gdsfa

Now, I would like to fetch the data only the number / strings alone

Column
abcd
edfd
gdsfa

OR

Column
123
321

Can some one please help me....

To bring back the numbers, you can use the IsNumeric() function like so:

select * from MyTable where IsNumeric(MyColumn) = 1

Or check where it is equal to 0 to find the other columns.