title: TSQL function to compare two strings
body: <p>Can anyone give me some sample TSQL code to compare two email addresses to check they are equal or not? </p>
  
  <p>CLR functions are not an option. I tried that but our DBA for some reason is totally against using CLR functions in SSMS. </p>
  
  <p>I know how to get the domain names (eg: mycompany.com) from the email address.</p>
  
  <p>Really appreciate any suggestions<br>
  Thanks in advance</p>