Dataset query case-insensitive value

user064854 · February 2020

Hi Dojo,

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 · February 2020

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 · February 2020

Hi,

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

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 · February 2020

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 · February 2020

Thanks GrantSmith, it work perfectly

Best Answer