Simple query... Table1 has a million SKUs (ie 006631251252) Table 2 has a unique list of SKUs (663125125) As in the example above, the SKU in table 2 can be contained in the SKU from table 1. If I do an inner join on the two tables above, there would be no match. I would like to create a join such that there is a match if Table 2 SKUs are contained in Table 1. I think the CONTAINS function is what needs to be used, but not sure how to do a join using CONTAINS. Thanks in advance, James
... View more