How to convert a column value from varbinary(max)
to varchar
in human-readable form?
The following expression worked for me:
SELECT CONVERT(VARCHAR(1000), varbinary_value, 2);
Here are more details on the choice of style (the third parameter).