I have two tables with serial numbers, however one table has more digits for the serial number. Such as Table1.SerialNumber is 123456789 and Table2.SerialNumber is 345678. They match in the middle digits.
Can you write a Join statement that matches Table2.SerialNumber with anypart of Table1.SerialNumber?
FROM [Table1] INNER JOIN Table2 ON [Table1].[Serial Number] Like Table2.%[Serial Number]%;
Obviously the above doesn't work because it doesn't like the % wildcards but this is what I am trying to do and I don't know if it is possible.