On Dec 19, 2009, at 3:12 PM, Igor Tandetnik wrote: > > To find all strings beginning with 'a', consider using something > like this: > > SELECT * FROM mytable WHERE mycolumn2 >= 'a' and mycolumn2 < 'b';
Or: SELECT * FROM mytable WHERE mycolumn2 GLOB 'a*'; D. Richard Hipp d...@hwaci.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
