Extract numeric data from text/numeric column

[johnaregan]

Hi
I have a varchar column holding numeric and text data. How would I be able to just extract the numeric data from this column?

Thanks in advance
John

 

[nigelrivett]

Depends on the server.
For sql server see

http://www.nigelrivett.net/RemoveNonNumericCharacters.html

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.