Re: Help on Removing "Junk" Characters

From: News <news_connection_at_yahoo.fr>
Date: Tue, 18 Oct 2005 15:32:28 +0200
Message-ID: <dj2tp8$bcn$1@apollon.grec.isp.9tel.net>

If you know what non-alphanumeric characters may be you can use:

update table set col = translate(col, 'A�', 'A') ;

"Robert" <boobie.webdeveloper_at_mailnull.com> wrote in message news:dj1ea4$ic7$1_at_reader2.panix.com...
> 10g
>
> Please help with this:
>
> How to write an UPDATE where REGEXP_REPLACE (or something else) can be
> used
> to replace any non-alphanumeric characters with NULL ?
>
> Several records have data that look like this:
>
> customer.companyname
> --------------------------------------------------
> Pericles Comidas cl�cas Guillermo Fern�ez
> Queen Cozinha L�cia Carvalho
> Supr�s delices
>
>
> Thanks
>
>
Received on Tue Oct 18 2005 - 08:32:28 CDT