Conversion from spaces to hex 000c

hemaarvind1 · Post by **hemaarvind1** » Wed Oct 24, 2012 10:22 pm

Hi Everyone,

could you please suggest how to get the spaces converted to hex 000c.

I guess I can use convert function ,but I am not sure of what values to be passed for the hex 000c. I suppose it is char(20) for spaces.

chulett · Post by **chulett** » Wed Oct 24, 2012 10:48 pm

Yes, you can use Convert() for this but you pass the decimal value to the CHAR() function. So just convert your hex values to decimal and use them there.

hemaarvind1 · Post by **hemaarvind1** » Wed Oct 24, 2012 11:01 pm

Thank you so much