HashBytes () T-SQL Function

Question

What is the most efficient way to convert the output of this function from varbinary () to varchar ()?

Answer 1

How about this:

master.sys.fn_varbintohexstr(@binvalue) 

Answer 2

For SQL Server 2008 use

 CONVERT(varchar, @binary, 1) 

1 - style 0x060D, 2 - 060D

http://msdn.microsoft.com/en-gb/library/ms187928.aspx

Answer 3

CONVERT (varchar, @binary)