Rob Willett wrote: >> Do you ever depend on any indexing on the "Text" column which is not COLLATE >> NOCASE ASC ? If not, then you should be able to speed up your search by >> defining the column the way you think of it. So in your table definition use >> >> "Text" TEXT COLLATE NOCASE ASC, > > We don?t think adding ASC is allowable
Indeed it isn't; ASC makes sense only for (sorting) an index. Regards, Clemens