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
www.psoug.org
click on Morgan's Library
click on Regular Expressions
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Mon Oct 17 2005 - 19:21:54 CDT
