Hi,
currently when querying a "varbinary" fields VC task output displays only System.Byte[] instead of the actual data store in this field.
querying the same field using SQL Server management studio I get the correct result.
please add support for query such field.

Thank you,
Gad

Hi

Just do a convert to varchar in your query:
vb is your varbinary field. The 0 at the end is to convert to text. Replace with 1, or 2 to get the HEX version instead. I think it's better to explicitly convert instead of relying on VC to guess what you want to convert to.

select convert(varchar(200), vb, 0)

Hi Thomas,
your solution works perfect.
thank you!
Gad