Posted by Analizer1 on 12/07/07 18:30

that worked Fantastic....
thank you very much

"Plamen Ratchev" <Plamen@SQLStudio.com> wrote in message
news:tJudnR8PRv38UcXanZ2dnUVZ_tWtnZ2d@speakeasy.net...
> 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]