DSXchange

We had issues in moving data from char to varchar fields. I have trimmed all char before writing to varchar. Is there anything else I should be looking at? thx

yah, char will pad all unused bytes with CHAR(0). Trim does not remove them. I use the convert function:

convert(char(0),'',inputcolumn)

The three-argument version of Trim() will remove them.

Performance Tip
Initialize a stage variable to Char(0) and do not derive it. That way the Char() function is evaluated only once per run, rather than once per row.

Simple and perfect solution. Very helpful :D

Thank you. It was simple (and presumably helpful) three years ago too.