By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,806 Members | 1,892 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,806 IT Pros & Developers. It's quick & easy.

binary data in char field

P: 6
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 Images
File Type: jpg data.jpg (12.3 KB, 102 views)
Mar 12 '09 #1
Share this Question
Share on Google+
1 Reply


P: 30
Refer to the following:
http://support.microsoft.com/kb/104829
Mar 12 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.