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
-
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!**1
Answers
-
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
1 -
Thanks GrantSmith, it work perfectly
0
Categories
- 7.3K All Categories
- 13 Getting Started in the Community
- 141 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 53 Domo Everywhere
- 2K Charting
- 1K Ideas Exchange
- 902 Connectors
- 236 Workbench
- 342 APIs
- 77 Apps
- 19 Governance & Productivity
- 234 Use Cases & Best Practices
- 50 News
- 473 Onboarding
- 572 日本支部