Re: [SQL] Case in-sensitive searches
Marin D <marin@iclub.techno-link.com>
From: Marin D <marin@iclub.techno-link.com>
To: Jerome Knobl <jknobl@mandanet.ch>
Cc: Mike Lemler <coronach@datacruz.com>, pgsql-sql@postgreSQL.org
Date: 1998-05-19T07:54:53Z
Lists: 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');
>