Received: from shaked.cc.openu.ac.il (shaked.cc.openu.ac.il [147.233.145.65]) by hub.org (8.8.8/8.8.8) with ESMTP id KAA04367 for ; Wed, 16 Sep 1998 10:42:33 -0400 (EDT) (envelope-from herouth@oumail.openu.ac.il) Received: from [147.233.159.109] (herouth@mac-herouth.pc.openu.ac.il [147.233.159.109]) by shaked.cc.openu.ac.il (8.8.5/8.8.5) with ESMTP id QAA06196 for ; Wed, 16 Sep 1998 16:42:11 +0200 (IST) X-Sender: herouth@shaked.cc.openu.ac.il Message-Id: In-Reply-To: <10676.980916@bo.nettuno.it> References: <19980916134810.21155.rocketmail@send101.yahoomail.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Date: Wed, 16 Sep 1998 16:42:36 +0200 To: pgsql-sql@postgreSQL.org From: Herouth Maoz Subject: Re[2]: [SQL] How to Make Case InSensitive??? At 16:14 +0200 on 16/9/98, Sferacarta Software wrote: > regular expression operators ^ stand for first character and $ stand > for last character: > > ~* '^india$' > > matches India > india > INDIA > > but not Indiana > New India Another way to think of it is like this: 'india' is eqivalent to "contains 'india'" '^india' is eqivalent to "starts with 'india'" 'india$' is eqivalent to "ends with 'india'" '^india$' is eqivalent to "is exactly 'india'" Herouth -- Herouth Maoz, Internet developer. Open University of Israel - Telem project http://telem.openu.ac.il/~herutma