I recommend creating a search field (text) and have a database trigger keep the field updated whenever other fields change. so Database trigger → Make changes to thing → set search field to a combination of the other fields (make them lowercase). Then when you go to search do searchField contains Input's value:lowercase
1 Like