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

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.

user064854

Thanks GrantSmith, it work perfectly