Since Igor's response I've been studying "The SQLite Query Planner" with great interest.
Staffan On Thu, Jul 23, 2015 at 4:59 PM, Bernardo Sulzbach < mafagafogigante at gmail.com> wrote: > > That's not quite the same. BETWEEN is inclusive of both ends. ('b' > BETWEEN 'a' and 'b') is true. > > Yes, you are right. I'm sorry for that, just wanted to point out that > (as most would expect) .. >= 'a' and .. < 'b' would not match > uppercase beginnings. > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >