Hi, How to make a case insensitieve index ? I tryed with [lower(fieldname)] and other combinations but this give me a syntax error.
The select will work with 'order by lower(fieldname)' but it should use the right index. -- View this message in context: http://www.nabble.com/how-make-a-case-insensitive-index-t1849023.html#a5047266 Sent from the SQLite forum at Nabble.com.