I have researched into this and I found 2 solutions to it:
- Using regex, which does not use the index and is very slow for my application.
- Create a duplicate field using tolower() or toUpper(), which again is not the ideal solution in my case as my dataset is huge.
Are there any other solutions to this problem ?