views:

1020

answers:

2

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

+1  A: 

How about this:

master.sys.fn_varbintohexstr(@binvalue)
Eric Z Beard
Works well, Thanks!
betelgeuce
A: 

CONVERT(varchar, @binary)