binary data in char field

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • trd79
    New Member
    • Apr 2008
    • 6

    #1

    binary data in char field

    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.
    Attached Files
  • Jibran
    New Member
    • Oct 2008
    • 30

    #2
    Refer to the following:
    http://support.microsoft.com/kb/104829

    Comment

    Working...