Received: from giasdl01.vsnl.net.in (giasdl01.vsnl.net.in [202.54.15.1]) by hub.org (8.8.8/8.7.5) with SMTP id LAA16957 for ; Tue, 1 Sep 1998 11:59:48 -0400 (EDT) Received: from [202.54.98.233] by giasdl01.vsnl.net.in; (5.65v3.2/1.1.8.2/03May97-0227AM) id AA22897; Tue, 1 Sep 1998 21:29:26 +0500 Message-Id: <35EC1A87.A9943@giasdl01.vsnl.net.in> Date: Tue, 01 Sep 1998 21:32:15 +0530 From: "S.Ramaswamy" Organization: Matrix Infotech Syndicate X-Mailer: Mozilla 4.05 [en] (Win95; I) Mime-Version: 1.0 To: pgsql-sql@postgresql.org Subject: How to Make Case InSensitive??? Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit When I use SQL statements, how can I make it case insensitive. If I use SELECT * FROM series WHERE NAME='India' I want to select rows including those where NAME='INDIA' / NAME = 'india' and so on. Can someone help me in the above?? Regards S.Ramaswamy