Looking for a solution to this that I can use in the query design window.

Basically, I have A list of text strings in one table, and a list of surnames in the next. I want to basically replicate a "contains" function in excel except I want to apply it to every string by every surname.

I tried Like [Surnames]![Field1] but as you can imagine that didnt work out too well.



So if any cell/string from table "UKClean" contains a word from the table "surnames", Place in query 1.

Thank you for your help in advance