2

I have researched into this and I found 2 solutions to it:

  1. Using regex, which does not use the index and is very slow for my application.
  2. 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 ?

Chris Barlow
  • 3,274
  • 4
  • 31
  • 52
Pi Horse
  • 2,350
  • 8
  • 30
  • 51
  • Closing as dupe, even though the question is "are there any answers *other* than this" because the answer seems to be no. – SomeKittens Jul 26 '13 at 21:45
  • @SomeKittens If the answer is no then it is not a duplicate since the linked answer does not answer this question – Sammaye Jul 26 '13 at 22:12

0 Answers0