Re: URGENT - REPLACE data problem (DECODE)
From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 8 Jul 2002 20:16:25 -0700
Message-ID: <92eeeff0.0207081916.81604a4_at_posting.google.com>
Date: 8 Jul 2002 20:16:25 -0700
Message-ID: <92eeeff0.0207081916.81604a4_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
SELECT RTRIM(TRANSLATE('Bill Gates123456', '123456789', '000000000'), 0) FROM dual;
HTH
//Rauf Sarwar
Received on Tue Jul 09 2002 - 05:16:25 CEST