I have cities in my data that have different cases. So I have “ware” and “WARE”. When I have results in the grid and I apply a filter, the filter is case sensitive so I have to select “WARE” or “WARE”. I need
the grid filter to be like my query where when I filter for “ware” I get all that match regardless of case like below.
where city = ‘ware’