I need to be able to search a text field using the Contains option in the full search where I can specify the various fields to be searched. But the Contains option returns any string matching the input value. I only want it to find instances where the whole word is found. For example, you have a text field such as “This sentence contains the word woman.” But, you are looking for “This sentence contains the word man.” The search would return both of these sentences because ‘man’ is included in ‘woman’. But if it were to execute a search for full words, then only the sentence with ‘man’ would be returned.
Is there a way to input a search or configure a search for whole words using Contains or some other approach?
Hope I stated this clearly.
Thanks so much for any suggestions!!!