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

How to add a field of hexa value in output file unloaded from BCP

P: 1
I have tried to add one field of hexadecimal value (x'09') into output file that unloaded by BCP.

I used cast(9 as varbinary(1)), it gave 0x09 in SQL management studio.

But when I used the same statement with BCP, it returned value of 3039.

Can anyone tell me how to add hexavalue field into the output file that unloaded by BCP?

Thanks for your help in advance.
Apr 11 '13 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 10K+
P: 12,370
It would help to see your command.
Apr 11 '13 #2

Post your reply

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