Varbinay data type

Hi all,

I have a database, with a field type: varbinary, this is the sample value of this field "0x0029FF69BD634E1D46EB92D312DADFD0B539", I want to view this data in readable way, but when I use convert(varchar, this_varbinary_field) the result is empty.

Please let me know the way to do that I can view this data field.

Thanks a lot.

In order to help it would be necessary of us to see an example of how you expect the equivalent for the "0x0029FF69BD634E1D46EB92D312DADFD0B539" value to be viewed. I.E. show us what the converted result is supposed to look like.

mkaras

It is also not clear from your posting just how you observed that the sample value of the field was "0x0029FF69BD6....". Could you shed some light on that?

mkaras