RE: Change nuber.+# to number

[Gorbounov,Vadim]

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 PM
To: Multiple recipients of list ORACLE-L
Subject: Change nuber.+# to number

Hi,
I want to get rid or those special char in a number string to a pure number, for an instance, from 89_. or 99,9 to 89 and 999.
Which function should I use in SqlPlus?
Thanks a lot,

 

Jack

 

Change nuber.+# to number