Hi, I'm trying to figure out if it's possible, using SQLite 2.8.13 (latest version), to do case-insensitive ordering on a column.
I read in an earlier message to try something like this: CREATE INDEX IDX ON MYTABLE (lower(FIELD)); Then SELECT * FROM MYTABLE ORDER BY lower(FIELD); But the CREATE INDEX takes an error; I don't think you can use user-defined functions with indexes. No? Is there any way to do this? I have about 1 million records that I would like select in a case-insensitive order.. I am using the win32 DLL distribution of SQLite. If not, maybe it's a good idea for v3.0? Thanks, // CHRIS
