Robert wrote:
> 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
>
>
I would be careful with that.
Most likely these are not junk characters, but your front end
fails to recognize them, and thus displays junk.
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
Received on Tue Oct 18 2005 - 12:47:54 CDT
