title: Generate MD5 hash string with T-SQL
body: <p>Is there a way to generate MD5 Hash string of type varchar(32) without using fn_varbintohexstr</p>
  
  <pre><code>SUBSTRING(master.dbo.fn_varbintohexstr(HashBytes('MD5', 'email@dot.com')), 3, 32)
  </code></pre>
  
  <p>So it could be used inside a view with SCHEMABINDING</p>