URGENT - REPLACE data problem (DECODE)

From: AR <AR69RA_at_gmx.net>
Date: Mon, 8 Jul 2002 22:24:30 +0200
Message-ID: <rxmW8.276$QA.7860_at_news.siol.net>

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 Mon Jul 08 2002 - 22:24:30 CEST

This message: [ Message body ]
Next message: Rauf Sarwar: "Re: URGENT - REPLACE data problem (DECODE)"
Previous message: Jim Kennedy: "Re: about segment setting"
Next in thread: Robert Boyle: "Re: URGENT - REPLACE data problem (DECODE)"
Reply: Rauf Sarwar: "Re: URGENT - REPLACE data problem (DECODE)"
Reply: Andy Triggs: "Re: URGENT - REPLACE data problem (DECODE)"
Reply: RK: "Re: URGENT - REPLACE data problem (DECODE)"
Reply: Edwin: "Re: URGENT - REPLACE data problem (DECODE)"
Reply: Aravind: "Re: URGENT - REPLACE data problem (DECODE)"
Reply: Robert Boyle: "Re: URGENT - REPLACE data problem (DECODE)"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message