I wish this helpful for you The original requestor has mentioned that the content resides within MarkLogic. Therefore, I will give a MarkLogic-Centric response for the use-cases based on the information available. Tuning for a full implementation including case sensitivity may take more understanding of the underlying features of MarkLogic: Case: "A.B C", "A B D.C" etc Under the hood, all content is indexed. The word indexes tokenize content and apply rules about case sensitivity and diacritic sensitivity when storing the content. Word boundaries are based on a sane set of defaults related to whitespace and punctuation marks. That means that the data is already well prepared for the items with some separation of characters. We can see this my Analyzing a sample of the above:
hope this fix your issue I want to receive records from column KEY_EXAMPLE only. When KEY_EXAMPLE column have records like "1234", or "1234a", code shows this kind of records, but when it have record like "abcd" it's not shown. , Why it's showing numbers or numbers+letters records only?