Hi,
I am trying to extract data from a legacy system. For reasons best known to themselves, the developers have stored what looks like binary data in a char(6) field. Within SQL Management Studio the field looks like a line of small squares.
How can I go about displaying this as a hexadecimal string?
(I have attached a screenshot)
Many thanks.
I am trying to extract data from a legacy system. For reasons best known to themselves, the developers have stored what looks like binary data in a char(6) field. Within SQL Management Studio the field looks like a line of small squares.
How can I go about displaying this as a hexadecimal string?
(I have attached a screenshot)
Many thanks.
Comment