Looking for the help about using substring option in the join columns.
Like
Table1.Filed = substring (Table2.Field,1,10)
Thanks
Aneel