this article may help you
http://www.sqlservercentral.com/articles/IsNumeric/71512/
SELECT col,
case when col NOT LIKE '%[^0-9]%' then col else '' end,
case when col LIKE '%[^0-9]%' then col else '' end
FROM <YOURTABLE>
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day