Received: from lucas.mandanet.ch (lucas.mandanet.ch [195.15.14.192]) by hub.org (8.8.8/8.7.5) with SMTP id CAA16304 for ; Tue, 19 May 1998 02:55:43 -0400 (EDT) Received: from thomas.mandanet.ch (thomas.mandanet.ch [195.15.14.193]) by lucas.mandanet.ch (NTMail 3.02.13) with ESMTP id ma007110 for ; Tue, 19 May 1998 08:59:39 +0100 Message-ID: <35612DDB.6A86EDA3@mandanet.ch> Date: Tue, 19 May 1998 08:59:39 +0200 From: Jerome Knobl Organization: MandaNET X-Mailer: Mozilla 4.04 [en] (WinNT; I) MIME-Version: 1.0 To: Mike Lemler CC: pgsql-sql@postgreSQL.org Subject: Re: [SQL] Case in-sensitive searches References: <3.0.5.32.19980518160401.007bd330@datacruz.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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'); JK Mike Lemler wrote: > Is there a paramater to a select statement that one can issue to make the > search case insesitive? Thanks > > Michael