Created by: croaky
ILIKE
is supported in Postgres but not other common SQL databases.
Use LIKE
and lower
ANSI SQL standards instead for broader support.
https://www-304.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.sqls.doc/ids_sqs_1388.htm https://www-304.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.sqls.doc/ids_sqs_1567.htm