# Case insensitive comparison in Glide Tables

**URL:** <https://community.glideapps.com/t/case-insensitive-comparison-in-glide-tables/26042>\
**Category:** Ask for Help\
**Created:** [April 26, 2021, 9:02am UTC](https://community.glideapps.com/t/case-insensitive-comparison-in-glide-tables/26042 "2021-04-26T09:02:59Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![vijay](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vijay/32/3259_2.png) [@vijay](https://community.glideapps.com/u/vijay)\
**Post date:** [April 26, 2021, 9:02am UTC](https://community.glideapps.com/t/case-insensitive-comparison-in-glide-tables/26042/1 "2021-04-26T09:02:59Z")

</div>

Hi, I am creating an app for a jumbled word game, where a jumbled word is shown and user has to guess the correct word and type it in.

I then compare the typed entry with the correct word, Both the typed entry and the correct word are stored in Glide tables.

When I use the If-Then-else to compare the entry with the correct word, it shows incorrect, if both are not of the same case. For example, Cat compared with cat gives False as the answer. How can I have the comparison done irrespective of the case?

I found a solution using =lower(), but that can be done only on Google Sheet. What if I am using only data in Glide tables?

---

<div class="post-metadata">

**Author:** ![vijay](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vijay/32/3259_2.png) [@vijay](https://community.glideapps.com/u/vijay)\
**Post date:** [April 26, 2021, 9:58am UTC](https://community.glideapps.com/t/case-insensitive-comparison-in-glide-tables/26042/2 "2021-04-26T09:58:03Z")

</div>

Solved by using =UPPER(), =LOWER() and =PROPER() to get columns for each case, and then used lookup to put it into Glide table from each column, and then did the comparison with each case word.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [April 26, 2021, 11:24am UTC](https://community.glideapps.com/t/case-insensitive-comparison-in-glide-tables/26042/3 "2021-04-26T11:24:07Z")

</div>

What happens if your user decides to use cAMeL cASe? 😉

This is yet another example of where having string manipulation methods inside the GDE would make life so much easier.

---

<div class="post-metadata">

**Author:** ![vijay](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vijay/32/3259_2.png) [@vijay](https://community.glideapps.com/u/vijay)\
**Post date:** [May 1, 2021, 10:35am UTC](https://community.glideapps.com/t/case-insensitive-comparison-in-glide-tables/26042/4 "2021-05-01T10:35:11Z")

</div>

True, Functions within GDE would help.

---

<div class="post-metadata">

**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\
**Post date:** [January 17, 2024, 4:52pm UTC](https://community.glideapps.com/t/case-insensitive-comparison-in-glide-tables/26042/5 "2024-01-17T16:52:28Z")

</div>


