Posted by Plamen Ratchev on 12/07/07 04:31

Hi,

One way to convert the varbinary to a hex string is to use the built-in
undocumented function fn_varbintohexstr, like this:

SELECT master.dbo.fn_varbintohexstr(@sid)

But please have in mind it is undocumented and unsupported (I see it is
still there even in SQL Server 2008 under the sys schema, but not guaranteed
to exist in the future).

An alternative and more reliable way would be to write your own TSQL or CLR
(if on SQL Server 2005) function, here is one example in TSQL:
http://support.microsoft.com/?id=104829

Another solution is to do this in client code.

HTH,

Plamen Ratchev
http://www.SQLStudio.com

[Back to original message]