Unanswered: Using LIKE to find any of the fields in one table in the fields of another
The title may be confusing, so here it is. I have a list of items in one table and a field (pageName) in another table that may contain one of the aforementioned items somewhere within that field. There is no fixed position within the field where the itemNo may be so I can't just use SUBSTRING(pageName,2,5) in(select itemNo from tblItem).
Logically, it's like I need to combine IN and LIKE: select pageName where pageName LIKE IN %select itemNo from tblitemNo%
But to the best of my knowledge, LIKE can only handle one comparison string.