Re: URGENT - REPLACE data problem (DECODE)
From: Robert Boyle <rboyle_at_cyantel.com>
Date: 9 Jul 2002 03:30:08 -0700
Message-ID: <8729a6fe.0207090230.1af19287_at_posting.google.com>
Bill Gates
Date: 9 Jul 2002 03:30:08 -0700
Message-ID: <8729a6fe.0207090230.1af19287_at_posting.google.com>
Have you tried the trim functionality in ORACLE?
sqlplus>SELECT RTRIM('Bill Gates123456','0123456789')
2 FROM dual
3 /
RTRIM('BIL
Bill Gates
This will work as long as the numbers are always on the right of the Name. There is a LTRIM function to. Look up tahiti.oracle.com and follow your version of Oracle for the documentation.
Cheers
R.
Received on Tue Jul 09 2002 - 12:30:08 CEST