Your first query looks fine and gives a expected results. If you want to search with like clause you can also introduce wildcard characters based upon your requirements to match the words (trailing or starting) When it comes to CONTAINS , it will also work for non-delimetered words (simplewords) for...