Received: from u1.abs.net (root@u1.abs.net [207.114.0.131]) by hub.org (8.8.8/8.7.5) with ESMTP id MAA20100 for ; Tue, 1 Sep 1998 12:38:38 -0400 (EDT) Received: from insightdist.com (nobody@localhost) by u1.abs.net (8.9.0/8.9.0) with UUCP id MAA08319 for pgsql-sql@postgreSQL.org; Tue, 1 Sep 1998 12:32:25 -0400 (EDT) X-Authentication-Warning: u1.abs.net: nobody set sender to insightdist.com!daveh using -f Received: from ceodev by insightdist.com (AIX 3.2/UCB 5.64/4.03) id AA57435; Tue, 1 Sep 1998 12:17:29 -0400 Received: from daveh by ceodev (AIX 4.1/UCB 5.64/4.03) id AA25696; Tue, 1 Sep 1998 12:17:29 -0400 Message-Id: <35EC1F0E.F300470F@insightdist.com> Date: Tue, 01 Sep 1998 12:21:34 -0400 From: David Hartwig Organization: Insight Distribution Systems X-Mailer: Mozilla 4.05 [en] (Win95; I) Mime-Version: 1.0 To: "S.Ramaswamy" Cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] How to Make Case InSensitive??? References: <35EC1A87.A9943@giasdl01.vsnl.net.in> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit S.Ramaswamy wrote: > 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?? SELECT * FROM series WHERE upper(NAME) = 'INDIA' or SELECT * FROM series WHERE NAME ~* '^india$'