if you use labkey's 'contains' filter to do a search, it's case insensitive. what i seemed to be seeing was that if you do a LIKE search through labkey but using raw SQL is that LIKE is case sensitive (which is what postgres is). ILIKE did not seem to be supported. I'm guessing labkey just passes like 'LIKE' through to pg, so we're inheriting postgres' behavior?

Should it be possible to write a SQL statement (not a labkey filter) against postgres that gives a case insensitive LIKE?

Thanks.