Access Partially match 2 lists

[Razvan]

Hello,
I'm trying to partially match 2 lists.
I have about 13000 lines in each one and I would like to match like 80% of the name for each one with what it can find in the other list. For example if there is "444 MGX" in one list and in the other I have "444 MGX company" I'd like to flag this.
Can something like this be done without entering all the criteria by hand? Is there a criteria similar to Like " " where I enter about 80% similarity or something?

 

[Abraham Andres Luna]

You can select each record in the first list, and then loop through each record in the results. In the loop you will then select any records from the second list that are like the first one.

If you need help writing the T-SQL statements then let me know and I will try my best.

Here is a link with more info on how to SELECT rows: https://msdn.microsoft.com/en-us/vba/access-vba/articles/retrieve-records-using-access-sql