Here is a way that I recently found using PATINDEX useful:

http://codeslammer.wordpress.com/2008/09/02/sql-server-string-manipulation-removing-non-numeric-characters/

I have a column that contains an ID number, but there may be text before and/or after...