Home Forums Article Discussions Article Discussions by Author Discuss content posted by Sean Smith E-Mail Validator RE: E-Mail Validator
JediSQL
SSCrazy
Points: 2117
More actions
June 2, 2010 at 1:25 pm
#1175539
Dennis,
I like your pattern matching approach. However, I was concerned about the 128 extended characters, so I suggest the last condition be modified to changed the ~ to a ÿ, like this:
OR @vParameter LIKE '%[{-ÿ]%'
Sincerely,Daniel