Re: [SQL] Case in-sensitive searches - Mailing list pgsql-sql

upper()/lower() are defined only for text fields. How to deal with charN ?

Thanx for the attention!

    Marin


          -= Why do we need gates in a world without fences? =-



On Tue, 19 May 1998, Jerome Knobl wrote:

> Hi,
>
> I found an inellegant sollution. You can put every character in uppercase
> like that :
>
>     Select * From table_membres where upper(nom) like upper('myname');
>