Trying to do a lookup from one table to the loaded table. Issue is when I try to do a lookup the exact name won’t be the same so i want to do something like in SQL where Database1.Name LIKE %dataloaded.name%.
Name loaded is “Apple Hill Incorporated”
In the Database where I’m looking up has “Apple Hill”.
Somehow I need to be apple to grab x number of words like maybe the first two and do a lookup using where LIKE %first two words%
so LIKE %Apple Hill% (like sql)
Is there a way to do that?