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.

```
SELECT HASHBYTES('SHA1','test') //works
SELECT HASHBYTES('SHA2','test') //returns null

```

What am I doing wrong?  

Is there a way to view the return value from `SELECT HASHBYTES('SHA2', 'test')`?

thanks