I have a list of 120 distinct field values; i need to see if the values in another field/ table ‘contain’ any part of these values ?
e.g for the value of ‘Animal Rights’ , is ‘rights’ or ‘animal’ contained in any of the field’s values and return all the results for this for all 120 values?