title: TSQL Email Validation (without regex)
body: <p>Ok, there are a million regexes out there for validating an email address, but how about some basic email validation that can be integrated into a TSQL query for Sql Server 2005?</p>
  
  <p>I don't want to use a CLR procedure or function.  Just straight TSQL.</p>
  
  <p>Has anybody tackled this already?</p>