Hello, Not sure if something similar has been posted but what i'm trying to do is a partial match of all the ids in one search result with those in another search (two different sources so can't return in one search). dummy data: Source 1                                                                                       Source 2 extendedproductcode                      code2                                          productcode           2233445566                                         101573                                       5566                           2233445567                                          245859                                      5567                           eg. search 1 from source 1 returns a list of numbers like this: 2233445566, 2233445567 etc Now search 2 from source 2 has data that looks like this: "5566", "5567" etc Question is, how do I return a full list of  results from search 1 (source 1 data) where the numbers look like "*5544", "*5567" .  For a one off case I can run simple search  the ids in source 1 using ="*5566", but I'm not sure how to do it for a list of productds say 100-200 long. As the list is dynamic, I can't hardcode the numbers/ids. So I have a list of productids from source 2 which I need to search for in source 1 by partial match on productID. If there is a match, I want to return in a table from source 1 extendedProductId, code 2, and also the partial match. So something like this: Query to return: extendedproductcode                      code2                                          productcode           2233445566                                         101573                                       5566                           2233445567                                          245859                                      5567    Thanks,           ... View more