Hi, I have pushed a small patch to add ILIKE keyword to Phoenix. It's simple and available there: PHOENIX-1273 <https://issues.apache.org/jira/browse/PHOENIX-1273> I'm pretty sure it is complete but it's a first draft for review. I still need to update the PhoenixSQL.g file. Thanks, JM