DSXchange

Hi ,

I have a join. Left key field is an integer fields,len 4 and right key field is a varchar,len 50. The join is not working even after trimming the right records. I guess the right records have got some special characters with them.

Please help.

Thanks,
Arnie

Don't rely on implicit conversions, do an explicit conversion so that the join key is identically defined in the left and right sources. Then see if you still have problems.