Not sure how to write a query to join on a partial string match. See screen shot for example. Table1 has a list of prefixes I need to find within the Caption of Table2. The Prefix differs in length, but is unique. For each match in Table2, I need to include some other info from Table1 in my output. If the LEN of Prefix was fixed, I'd use the LEFT x characters of Caption, but that's not the case. Any thoughts appreciated.