Dataset query case-insensitive value

user064854

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. 

 

GrantSmith

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.

Neeti

Hi,

 

I have found something on case-sensitivity. Check if you can do this way?

 

https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/Return-Capitalized-UPPER-or-CamelCase-Characters-in-Column-Names/td-p/34418

 

Please linke if it gives you any help.

**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"

 

Thanks,

Neeti

user064854

Thanks GrantSmith, it work perfectly