Re: Taking punctuation out of fields

From: John Alexander <jalexander_at_summitsoftwaredesign.com>
Date: 2000/07/04
Message-ID: <8Ea85.3164$ez.27684_at_typhoon.tampabay.rr.com>#1/1

SQL> select replace ('ABC,DEF,GHI',',')
  2 from dual
  3 /

REPLACE('

---

ABCDEFGHI SQL> Neil Deaville <neil_at_funkcity.demon.co.uk> wrote in message news:8jqmvr$8ed$1_at_gxsn.com...
> My client wants me to produce a large table, 200+ columns, for them to
> import into Excel.
>
> They want the punctuation ,especially commas removing from all of the
 data.
>
> Is there an easy way to do this?
>
> Cheers
>
> Neil
>
>
Received on Tue Jul 04 2000 - 00:00:00 CEST