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@xxxxxxxxxx
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@xxxxxxxxx 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

.

Relevant Pages

  • RE: switch(true) in c#
    ... None of your respondants are empathetic. ... case true" construct rocks. ... It is especially useful for filtering out error ... "Frank" wrote: ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: [Xnews] Gimme a list of bad/bothersome/annoying/whatever remailers. Please.
    ... trolls/kooks/etc., ... Frank does have a novel idea there. ... Filtering *all* of Google Groups, ... Killing all posts from Google Groups. ...
    (news.software.readers)
  • Re: Reliable Firewall - Web Content Filter
    ... This group is no replacement for quality time spent with a browser and google. ... As Frank said, watchguard makes a decent product, but I've found its interface clunky, especially if you want to filter by user and not computer (IP filtering is just easier.) SonicWall offers products that do this. ...
    (microsoft.public.windows.server.sbs)
  • Re: Sharepoint List Question
    ... multi-choice field BUT you can't group on multi-choice fields. ... the choices being the US States and where multichoice is allowed. ... Filtering would be as above. ... > to accomplish what I am looking for let me know - right now the ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Prevent e-mails being sent to certain domains
    ... to send emails to some domains, ... Filtering", fill Recipients, ... but I'm not sure how to accomplish this. ...
    (microsoft.public.exchange.admin)