in reply to SQLServer varbinary headache

Another alternative would be to convert the varbinary to varchar in SQL: 
select ..., convert(varchar, sid), ... from sysusers

[download]
Michael

Replies are listed 'Best First'.
Re: Re: SQLServer varbinary headache
by bfdi533 (Friar) on Apr 23, 2004 at 19:48 UTC

    Yes, that is not a bad idea but since it is a binary value, you get the converted binary value as a string. Still looks like garbage as it contains non-printable characters.

    Thanks for the input though.

    Ed

[reply]
      Hmmm - you're right. I thought it would convert to a hex string. Guess I'll have to look into this...

      Michael

[reply]

In Section Seekers of Perl Wisdom