Query to Display Where a Column Contains Alphanumeric Data??

Question

query to display where a column contains alphanumeric data and i want to retrieve both string and numeric data separately into two columns
as
column
...................
abc
efg
123
456