Re: How to check for special charcters in an email address using plsql code?

vkatekan_at_yahoo.com schreef:

> Hi There,
> I am trying to write a plsql function to filter an email address which
> has a special address in it. I tried to filter them out by creating a
> table for bad charcters (i.e Chr(0...31 & 127...255), but this is also
> filtering out an email address with '_' charcter and just wondering
> how can I accomplish this one.
>
> Thank you very much in advance for all your inputs.
>
> Regards,
> Rao

escape_sc (Special Characters) and escape_url functions should be able to accomplish that Received on Fri Aug 18 2006 - 07:42:16 CDT