Toad World® Forums

How to filter grid non-case sensitive???

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.

Select *

From customers

where city = ‘ware’

Hi Matt,

I’m not sure I understand what grid/results you are talking about -can you please specify your case.
Anyway I have checked how “DATA” tab column filters work on case sensitive table - even if you select AAA you will get both AAA and aaa, however if you will use server side filters - you will get what you type (AAA or aaa).