Received: from server.iclub.techno-link.com (server.cybernet.bg [212.36.3.249] (may be forged)) by hub.org (8.8.8/8.7.5) with ESMTP id EAA23905 for ; Tue, 19 May 1998 04:02:01 -0400 (EDT) Received: from localhost (marin@localhost) by server.iclub.techno-link.com (8.8.8/8.?.?) with SMTP id KAA03464; Tue, 19 May 1998 10:54:54 +0300 Date: Tue, 19 May 1998 10:54:53 +0300 (EET DST) From: Marin D To: Jerome Knobl cc: Mike Lemler , pgsql-sql@postgreSQL.org Subject: Re: [SQL] Case in-sensitive searches In-Reply-To: <35612DDB.6A86EDA3@mandanet.ch> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII 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'); >