Hi Calvin, 28 Jul 2021 21:43:40 C Hamilton <adenacult...@gmail.com>: > If I use LIKE instead of ILIKE then it works. It is like ILIKE was not > implemented for GeoPackage. Can anyone verify this?
Yes, there seems to be no iLike in sqlite: https://stackoverflow.com/questions/15480319/case-sensitive-and-insensitive-like-in-sqlite And therefore neither in geopackage. Regards Anita
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user