Received: from pobox.fgg.eur.nl (pobox.fgg.eur.nl [130.115.152.9]) by hub.org (8.9.3/8.9.3) with ESMTP id DAA26020 for ; Wed, 8 Dec 1999 03:12:40 -0500 (EST) (envelope-from schoonewille@coh.fgg.eur.nl) Received: from coh.fgg.eur.nl (coh-236-229.pc.fgg.eur.nl [130.115.236.229]) by pobox.fgg.eur.nl (8.9.3/8.9.3) with ESMTP id JAA25363 for ; Wed, 8 Dec 1999 09:12:40 +0100 (MET) Message-ID: <384E12F0.E5F2F858@coh.fgg.eur.nl> Date: Wed, 08 Dec 1999 09:12:32 +0100 From: Fred Schoonewille Organization: Erasmus University Rotterdam X-Mailer: Mozilla 4.61 [en] (Win95; I) X-Accept-Language: en MIME-Version: 1.0 To: "pgsql-sql@hub.org" Subject: select a part of a name Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi, I am trying to select a part of a name from the columm NAME, e.g. sql asks the user for input like: jone sql should give all names which begin with or containing 'jone' -jones -Tom-Jones Working with: select * from TEST where NAME= '&name' finds only exact matches Can I use e.g. % ? -- ----------------------------------- Fred Schoonewille Applicatiebeheer Computer Ondersteuning Hoboken ----------------------------------- http://www.eur.nl/fgg/coh -------------------------------------------------------