<div dir="ltr">Thanks everyone for that explanation. This does complicate the ability to set an expression filter in a plugin when it depends on the data source type. I'm not sure what to do about that.<div><br></div><div>Regards,</div><div>Calvin</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Jul 28, 2021 at 8:00 PM Anita Graser <<a href="mailto:anitagraser@gmx.at">anitagraser@gmx.at</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
 
 <div> <span dir="ltr" style="font-family:sans-serif">Hi Calvin,</span>
  <br>
  <br> <span dir="ltr" style="font-family:sans-serif">28 Jul 2021 21:43:40 C Hamilton <<a href="mailto:adenaculture@gmail.com" target="_blank">adenaculture@gmail.com</a>>:</span>
  <br> <span dir="ltr" style="font-family:sans-serif">> If I use LIKE instead of ILIKE then it works. It is like ILIKE was not implemented for GeoPackage. Can anyone verify this?</span>
  <br>
  <br> <span dir="ltr" style="font-family:sans-serif">Yes, there seems to be no iLike in sqlite:</span>
  <br>
  <br> <span dir="ltr" style="font-family:sans-serif"><a href="https://stackoverflow.com/questions/15480319/case-sensitive-and-insensitive-like-in-sqlite" target="_blank">https://stackoverflow.com/questions/15480319/case-sensitive-and-insensitive-like-in-sqlite</a></span>
  <br>
  <br> <span dir="ltr" style="font-family:sans-serif">And therefore neither in geopackage.</span>
  <br>
  <br> <span dir="ltr" style="font-family:sans-serif">Regards</span>
  <br> <span dir="ltr" style="font-family:sans-serif">Anita</span>
  <br>
 </div>

</blockquote></div>