Problem with special character in joining

arnie_nits · Post by **arnie_nits** » Mon Sep 14, 2009 10:21 am

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

ArndW · Post by **ArndW** » Mon Sep 14, 2009 10:49 am

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.