Varbinary to literal varchar copy in SQL Server 2005

Question

How can I get from this binary version of SQL Server:

0x63C34D6BCAD555EB64BF7E848D02C376

To this varchar?

'63C34D6BCAD555EB64BF7E848D02C376'

Answer 1

declare @B varbinary(max) = 0x63C34D6BCAD555EB64BF7E848D02C376
declare @C varchar(35)

set @C = stuff(upper(sys.fn_varbintohexstr(@B)), 1, 2, '')

select @C

Result:

63C34D6BCAD555EB64BF7E848D02C376