On 14 Jul 2011, at 5:37pm, Black, Michael (IS) wrote: > Would glob be faster than like? Since I assume like has to case-convert?
Given your SELECT string: >> select * from tsamov where tsamov_code like 'AFG%' If you want speed don't use either, use SELECT * FROM tsamov WHERE tsamov_code BETWEEN 'AFG' AND 'AFGzzzzz' Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users