Does it make a deal?
SQL select translate('#33',
'1234567890#,_', '1234567890') from
dual;
TR--33
-Original Message-From: Liu, Jack
[mailto:[EMAIL PROTECTED]Sent: Thursday, July 31, 2003 2:10
PMTo: Multiple recipients of list ORACLE-LSubject:
Change nuber.+# to number
One way that might work is to use the translate function. For Example:
SQLr
1* select
translate('numberstring',1||translate('numberstring','0123456789','
'),'1') from dual
Enter value for numberstring: 89_.
Enter value for numberstring: 89_.
old 1: select