case-insensitive like operator

Hello All,

I have a following problem:

We have ported MS Acess database to PostgreSQL. Everything ok, but our
user are used to search data in tables using filters, and Access does
case insensitive search, but when working with Postgres database it
converts filters into queries with 'like' operator. So is there any
way to make 'like' operator case insensitive? Or maybe somebody has
the same problems and knows the solution?

Best regards,
 Yury                          mailto:yura@vpcit.ru