title: SQL Server 2008 R2 HASHBYTES SHA2 returns null
body: <p>I am trying to use HASHBYTES with SHA2_512 as the algo. However when I try to do it in SQL Server Management Studio all that I get is null.</p>
  
  <pre><code>SELECT HASHBYTES('SHA1','test') //works
  SELECT HASHBYTES('SHA2','test') //returns null
  </code></pre>
  
  <p>What am I doing wrong?<br>
  Is there a way to view the return value from <code>SELECT HASHBYTES('SHA2', 'test')</code>?</p>
  
  <p>thanks</p>