Yes indeed, when you create a filter in a query, its values are case-sensitive. So, if you set a location filter to "Iowa", it returns records with the uppercase "Iowa", but not the lowercase "iowa".

To include records regardless of casing:

• In Builder mode, use a calculation with a LOWER() function as the filter, which converts its values to lowercase. For example, LOWER(TBL.STATE) = 'iowa'.
• In Advanced Query mode, use a regular expression REGEXP_LIKE condition with an i flag, which makes the criteria case-insensitive. For example, SELECT * FROM table WHERE REGEXP_LIKE(column, ‘(?i)ab’).

Learn more in Support Center