vkatekan_at_yahoo.com schreef:
> Thank you, Frank. But somehow the escape_sc function is not working for
>
> n_d_t[b_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
>
What's that - a mutibyte character? Are these allowed at all?
or is that why you want to filter them out?
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
Received on Fri Aug 18 2006 - 14:12:18 CDT
