I have a table of interal email addresses and need to check, when a user enters a new email address, that it does not contain any illegal characters. The properform is firstnamelastname@thisbank
However, I tried the attached which works but I would have to list out all the characters that are not allowed (except the @ sign). I was just wondering if there is a better way?
SELECT tblEmailAddress.BR_NBR, tblEmailAddress.EmailAddressTo
WHERE (((tblEmailAddress.EmailAddressTo) Like '*!*' Or (tblEmailAddress.EmailAddressTo) Like '*?*'));