Postgres need ILIKE

Hi All

I need to do a case insensitive LIKE query in Postgres yet I have no options to use ILIKE, SIMILAR or the lower() option.

Example a search for “remove ms” should find “Remove MS”, “remove Ms”, “REMOVE MS”.

Note: No I can’t preset the string on save as it is free text storage - the can type in anything.

Any ideas?

Community Page
Last updated: