Re: [GENERAL] case-insensitive like operator

Yura,

As you have no control over the queries generated by MS Access I guess
you need to create extra columns which hold the uppercase version of the
data. Then to search use these columns and uppercase the data you are
searching for

eg if you have a column name then add a new column name_upper, change
your data entry to always put upper(name) into name_upper

Your search should be where name_upper like "UPPERCASED VALUE"

Dave

yura wrote:
>
> 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(at)vpcit(dot)ru
>
> ************