Received: from mx99.openu.ac.il (arbel.openu.ac.il [147.233.32.4]) by hub.org (8.9.3/8.9.3) with ESMTP id IAA07313 for ; Sun, 25 Jul 1999 08:47:25 -0400 (EDT) (envelope-from herouth@oumail.openu.ac.il) Received: from talmon.openu.ac.il (talmon.openu.ac.il [147.233.32.11]) by mx99.openu.ac.il (Postfix) with ESMTP for id AB45D4B57A; Sun, 25 Jul 1999 15:47:24 +0300 (IDT) Received: from [147.233.159.109] (mac-herouth.pc.openu.ac.il) by talmon.openu.ac.il (Netscape Messaging Server 3.54) with ESMTP id AAA16CB; Sun, 25 Jul 1999 15:50:42 +0300 X-Sender: herouth@shaked.cc.openu.ac.il Message-Id: In-Reply-To: <199907242311.QAA27601@uno.tksoft.com> References: from "Kenneth Jacker" at Jul 24, 99 11:13:19 am Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Date: Sun, 25 Jul 1999 15:47:58 +0300 To: "tjk@tksoft.com" , khj@cs.appstate.edu From: Herouth Maoz Subject: Re: [SQL] Expr Abbreviations/Functions? Cc: pgsql-sql@postgreSQL.org At 02:11 +0300 on 25/07/1999, tjk@tksoft.com wrote: > You could merge the fields and search with : > > select * from tablex where lower(f1||f2||f3) ~ 'foo'; Nah. If f1 is 'Narf' and f2 is 'oodp', it will match... Herouth -- Herouth Maoz, Internet developer. Open University of Israel - Telem project http://telem.openu.ac.il/~herutma