How to convert binary data to string?

[sypi]

Hi,

I'd need to construnct an EXEC statement in my script I am pretty much stuck with data conversion. I need to compare a binary variable with a SID value to an actual SID found in ..sysusers.

Whe I construct the EXEC statement the whol line has to be string and I need to find a way to use the binary data as string.

So far, I tryed to play with CONVERt and CAST, but could not succeed.

A simplified version of what I tried to do:

declare @t_sid binary(85)
select @t_sid = 0x01050000000000051500000043170A324D64492E235F636B 18BA0400000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000 0000000000000000000000
print convert(nvarchar(10), @t_sid)

This results a nice square character, nothing else...

Any I idea dear expoerts?

[Deven123]

Convert and Cast definitely won't work in this case. When you store Binary data into table. it does some encryption and then saves encrypted data to table, so how come SQL converts encrypted data to string without knowing the key?
We have to find someother way to decrypt the binary data and then convert/cast.

I ll get back if I find any useful...:)

Deven

[Archeks]

here it is..., Stored Procedure to convert.

http://support.microsoft.com/kb/104829