Re: URGENT - REPLACE data problem (DECODE)
From: Aravind <rfjam4_at_yahoo.com>
Date: 9 Jul 2002 08:12:46 -0700
Message-ID: <6f1f2925.0207090712.3db1a3fd_at_posting.google.com>
Bill Gates
Date: 9 Jul 2002 08:12:46 -0700
Message-ID: <6f1f2925.0207090712.3db1a3fd_at_posting.google.com>
"AR" <AR69RA_at_gmx.net> wrote in message news:<rxmW8.276$QA.7860_at_news.siol.net>...
> Hello all!
>
> how can i "clean" data in Sqlplus in next case:
>
> i have something like
> Bill Gates123456
> Pamela Anderson532544
> Britney Spears42323
>
> i want to have
> Bill Gates
> Pamela Anderson
> Britney Spears
>
> so i want to get rid of all numbers
>
> i try to make something with decode, but i can't handle it, please help
This may work
SQL > select initcap(translate(lower('Bill Gates12949494'),
'abcdefghijklmnopqrstuvwxyz0123456789',
'abcdefghijklmnopqrstuvwxyz'))
from dual;
INITCAP(TR
Bill Gates
Good Luck Received on Tue Jul 09 2002 - 17:12:46 CEST