Hi Yury,
I do not know the most correct solution but I used a work around while
encountering a similar problem
select * from table_name
where upper (field_name) like 'SOME_THING_IN_UPPERCASE'
Hope it helps.
- Cheers
- Shad.
+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - +
| Each human owes infinitely more to the human race than to the |
| particular country in which he was born. -- Francois Fenelon |
+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - +
On Sat, 15 Jan 2000, 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@vpcit.ru
>
>
>
> ************
>