finding records with a field value that is part of a word string
I need fo perform find based on a field value being a part of a string of words.
I have a table containing codes of teachers like LT,CMB,FR,... etc
then I am given a string of codes like "CMB_FR" which can vary in number of words
Now I need to perform a find which will give me all records containing either CMB of FR
if I know that the string contains only two words I can compose a find with two lines one for each but I need it to be general for any number of words
Can any body suggest a way to do that