Re: [GENERAL] case-insensitive like operator - Mailing list pgsql-general

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
>
>
>
> ************
>