HashBytes() Function T-SQL

Question

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

Eric Z Beard · Accepted Answer · 2008-09-16 15:22:26Z

6

How about this:

master.sys.fn_varbintohexstr(@binvalue)

answered Sep 16, 2008 at 15:22

Eric Z Beard

38.5k28 gold badges102 silver badges147 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Cheburek · Accepted Answer · 2011-11-02 11:53:04Z

2

For SQL Server 2008 use

CONVERT(varchar, @binary, 1)

1 - style 0x060D, 2 - 060D

answered Nov 2, 2011 at 11:53

Cheburek

2,11322 silver badges32 bronze badges

Amel · Accepted Answer · 2009-05-20 12:16:41Z

1

CONVERT(varchar, @binary)

answered May 20, 2009 at 12:16

Amel