DSXchange

Hi,

I have a char field coming from input and i am doing a lookup from DB which have a datatype of char. When i am deploying this as a serivce i am getting output as "��&#0" which are special characters.

is there a way to eliminate these ? If we use varchar we wont get it but we cant do a lookup against char to varchar.....please help me out

Check the setting of APT_STRING_PADCHAR environment variable.

it is set to 0x0 ...not sure what it must be..plz help me out

its a Char (4) data type

Thanks a lot for your help...I could solve it out...I made APT_STRING_PADCHAR....as 0x20 and used the trim function - Trim(<Col name>,Char(0),'A')