When calling ToDatasourceResults it wraps both sides of the filter criteria in LOWER() so that it can do case insensitive queries. We are using it on a DB2 iSeries database and would like to be able to add indexes to improve the performance of the queries.
1. the DB is case sensitive and cannot be changed
2. we can put an upper case index (which would get used) but not a lower case one
I'm looking for some method of changing the LOWER() to UPPER() when using ToDatasourceResults preferably without having to write my own version of it. Is there anywhere in the code that I can override to modify this behaviour?