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

[cmshea]

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.

[Rabbit]

It would help to see your command.