Re: URGENT - REPLACE data problem (DECODE)
From: RK <rajXesh_at_hotmail.com>
Date: 9 Jul 2002 05:19:10 -0700
Message-ID: <548b9514.0207090419.44587980_at_posting.google.com>
Date: 9 Jul 2002 05:19:10 -0700
Message-ID: <548b9514.0207090419.44587980_at_posting.google.com>
Try using the Translate function instead of Decode
- rajXesh
"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
Received on Tue Jul 09 2002 - 14:19:10 CEST