Chris,

Definitely an interesting read. I'll look forward to your future articles on the CLR. In the meantime, I was just curious where you came up with that expression to validate an email address. Did you code that yourself, or is there a tool / function that will help you generate the validation expression?

SET @regex = N'^([\w-\.]+)@((\[[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.)|(([\w-]+\.)+))([a-zA-Z]{2,4}|[0-9]{1,3})(\]?)$'

Jason