AnsweredAssumed Answered

finding records with a field value that is part of a word string

Question asked by med on Mar 5, 2013
Latest reply on Mar 11, 2013 by med

Title

finding records with a field value that is part of a word string

Post

     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

Outcomes