Dataset query case-insensitive value

Hi Dojo,

I have followed the documentation on

to query dataset. 
However i can't find how to make a query with case-insensitive value, could you please help me solve this problem. 


Best Answer

  • GrantSmith
    GrantSmith Indiana 🥷
    Answer ✓

    You can use either UPPER(`Field`) or LOWER(`Field`) to check values without worrying about the case.


    For Example:


    SELECT `Field`
    FROM table
    WHERE UPPER(`Field`) = UPPER(`Value`)

    You can wrap the Field selection at the top in either UPPER or LOWER if you're not interested in the case of the original value.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**


This discussion has been closed.