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
Problem with special character in joining
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 101
- Joined: Mon Aug 13, 2007 2:32 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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>