I am trying to search a field of text data but Web intelligence will only provide an answer if the case of the search term exactly matches the case of the word as it appears in the data field.

Let's illustrate this with a practical example. Let's say I have a database of case notes, all of which are contained in a single field 'Casenote'. Each case consists of ordinary text up to 200 characters in length total.

My filter is constructed as follows (note that the last field is prompted from the user)

Casenote Matches pattern %Trump%

MY expectation, or how I want my query to work in practice, is that Webi would return any entry which contains Trump, TRUMP, tRUMp, TRumP etc etc etc

In practice though the search is case sensitive so in the above filter the entries returned would all have 'Trump' in them but an entry with simply 'TRUMP' would not be returned.

My question is - how can one use webi to make a case insensitive search based on a single piece of data provided by the user? I have researched this and tried a number of different ideas to no success. First there is no capacity to do a fuzzy match. Secondly I could do some manipulation when designing the report but I have no way to pass the user provided piece of data 'Trump' to the report.

Can anyone help? Please note that I am told the version of Webi I am using is somewhat old so later versions of Webi may additional tools to solve this problem.

Thanks for your help

Peter

I design a query to search data but it was a case sensitive search. I expected it to be case insensitive.