relational operators for oracle sql

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?

Sorry, but this question is much more appropriate for Oracle SQL forum then Toad…here

:slight_smile: