Hi all,I'm wondering if anyone knows if it's possible to configure Derby so that searches on CHAR/VARCHAR fields are case insensitive by default?
I'm guessing that if the answer is no, the solution is to just do a LOWER() or similar on the field and compare it that way. I'm guessing if you do that though, it won't use the index if the field is indexed?
Jon
