Wednesday, January 14, 2015

SQL: Convert a Hash to a Varchar

For some reason this task always stumps me, so here is the solution:
CONVERT([varchar](512), hashbytes('sha', col), 2)
Thanks to Basit