It sounds like you need regular expressions for which you most probably will
need to load a java regexp package into the db and then create a pl/sql
wrapper function for it. There is also a pattern match function in the owa
package which may help you out.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Peter Amberg" <son42uk_at_yahoo.co.uk> wrote in message
news:f8232d10.0312030449.38c691aa_at_posting.google.com...
> 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 - 07:13:05 CST
