title: HashBytes('MD5', SomeValue) returns wrong md5 hash
body: <p>I`m trying to crate view what will return md5 hashed value like suggested in this <a href="http://msdn.microsoft.com/en-us/library/ms174415.aspx" rel="nofollow">MSDN article</a>
  HashBytes return wrong value if I try to use column. For example:</p>
  
  <pre><code>select Value, CONVERT(NVARCHAR(32),HashBytes('MD5', 'test'),2) from SomeTable
  </code></pre>
  
  <p>result is 246A848AF2F8394E3ADBC738DBE43720</p>
  
  <p>but when I try </p>
  
  <pre><code>select  Value, CONVERT(NVARCHAR(32),HashBytes('MD5', Value),2) from SomeTable
  </code></pre>
  
  <p>result for cell with Value test is C8059E2EC7419F590E79D7F1B774BFE6</p>