On 7/14/2011 12:01 PM, Pavel Ivanov wrote: >> could the next query use the tsamov_code index ??: >> select * from tsamov where tsamov_code like 'AFG%' > > Only after > pragma case_sensitive_like = true;
... or if the index uses COLLATE NOCASE clause. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users