Page 1 of 1

Conversion from spaces to hex 000c

Posted: Wed Oct 24, 2012 10:22 pm
by hemaarvind1
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.

Posted: Wed Oct 24, 2012 10:48 pm
by chulett
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.

Posted: Wed Oct 24, 2012 11:01 pm
by hemaarvind1
Thank you so much :)