[Q] Removing all characters except some

I have a VARCHAR column in some table T. How can I zap away all characters from the string except digits? I need this in a SELECT clause, I need to order the entries by the integer values within the string. There may be non-digit characters anywhere in the string, I can't just use SUBSTR.

Any help greatly appreciated!

Peter Received on Wed Dec 03 2003 - 06:49:49 CST