Regular Expressions

I'm currently looking for an example on how to code this, but maybe I can take a shortcut and someone will do it for me. LOL

Anyhow, I need a regular expression to filter out any values with special characters: !#$%^&*()+=<>,?"':;{}[]|\/

So far I can get the first character to be a valid one:

regexp_like (c1, '(^[A-Z0-9_-])');

I mean, this is really for email address validation. So, there can be no special characters in it.......I'm still trying things, but, maybe someone will just give the answer.

Thanks all! Received on Wed Aug 06 2008 - 14:56:40 CDT