Re: [GENERAL] case-insensitive like operator

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