We need to search or query for specific text in a text field. However searching for a specific word doesn't always work. I know that the text fields contain these words but how can we insure that a search or query will work properly?
In some cases searches will not always be successful in finding a word or text string. Try using a query as a search function instead. If this is still not producing favorable results, then perform the search or query on the word (or words) by placing an asterisk before the word you are searching to find. For instance, when searching for the work "car", that doesn't produce a positive result, use "*car" instead. This will normally produce positive results and the word will be found in the text field search or query.