Dataset query case-insensitive value

Hi Dojo,

I have followed the documentation on 
https://developer.domo.com/docs/dataset-api-reference/dataset#Query%20a%20DataSet

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!**

Answers

This discussion has been closed.