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

Thank you, Frank. But somehow the escape_sc function is not working for

n_d_t_at_yahoo.coma
email address. Any thoughts, why it's not filtering out this one and is there any generic plsql function to validate an email address?

Regards,
Rao

Frank van Bortel wrote:
> 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 - 10:26:17 CDT