I have a data table that has text data fields that contain wildcards? How can I join 2 tables on a query like;
LEFT JOIN Table2
ON Table1.Field1 = Table2.Field1
So if Table1.Field1 contains ‘318A__3’ and Table2.Field1 contains ‘318A003’ it would match and the query would return ‘318A003’ along with all the other fields in that record from both tables. The 5th and 6th position of Table1.Field1 in this example have the underscore but it may not always be in the 5th and 6th position.