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>


"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

Original text of this message