123 MAIN ST
The other table has the format of:
123 MAIN STREET VANCOUVER
I know that I can change the first to be exactly the same as the second, but then I have to do the same with
123 W 1ST AV
1323 W 1ST AVENUE VANCOUVER
...etc.
Is there a way to do an SQL-like "IN" for the merge? That is, to merge where the first address is IN the second?
Thanks