Received: from gateway.indvalley.com (unknown [203.195.208.1]) by postgresql.org (Postfix) with SMTP id A5789475484 for ; Fri, 15 Mar 2002 01:30:53 -0500 (EST) Received: (qmail 1071 invoked from network); 15 Mar 2002 06:29:41 -0000 Received: from unknown (HELO GURU) (192.168.0.20) by 192.168.0.63 with SMTP; 15 Mar 2002 06:29:41 -0000 Date: Fri, 15 Mar 2002 11:54:44 +0530 From: Gurudutt X-Mailer: The Bat! (v1.52f) Reply-To: Guru Organization: Indus Valley X-Priority: 3 (Normal) Message-ID: <89063021.20020315115444@indvalley.com> To: arun kv Cc: PGSQL Subject: Re: case insensitive search In-Reply-To: References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200203/28 X-Sequence-Number: 997 Hello arun, ak> how to do a case insensitive search on postgresql database. i will ak> enter a keyword in text field and it has to search for that keyword in ak> keywords field of table and should be case insensitive. why don't you use "ilike" to search for the pattern in the database. -- Best regards, Gurudutt mailto:guru@indvalley.com Life is not fair - get used to it. Bill Gates