Case Insensitive filtering

Hello, in my database I have data like:
1. abc
2. ABC
3. Abc
in field filter, it's showing all of them. but is it possible to treat these 3 is same? means I need case insensitive feature which will treat all of them as same. Is it possible through metabase or do I need to modify my database for this?

Hi @kayumuzzaman
You would need to transform your database. Metabase currently does not have a way for you to do such manipulation of the filter list.

okay thanks!

@flamber what do you mean by "You would need to transform your database"?

Can you give an example please?

@abhay Edit your database data, or create a view on your database which transforms the data (lowercase, uppercase, etc).