Hi Gilles, 'like' is case-insensitive.
so: select * from customers where city like "%ville%"; would match "villes" or "VilleS". Rgds, Simon 2008/6/20 Gilles Ganault <[EMAIL PROTECTED]>: > Hello > > Is there a way for glob to be case-insensitive? I'd like to retrieve > all rows where the city name can be a mix of upper- and lower-case > letters, eg. > > select * from customers where city glob "*ville*"; > > would match "ville" or "Ville". > > Thank you. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
