Received: from eba-haus.de ([149.228.241.83]) by hub.org (8.9.3/8.9.3) with SMTP id JAA08434 for ; Wed, 1 Dec 1999 09:55:09 -0500 (EST) (envelope-from DieringG@eba-haus.de) Received: from kopo001 by eba-haus.de;Wed, 01 Dec 1999 14:50:24 GMT with Novell_GroupWise; Wed, 01 Dec 1999 15:50:24 +0100 Message-Id: X-Mailer: Novell GroupWise 5.5 Date: Wed, 01 Dec 1999 15:50:09 +0100 From: "Gerhard Dieringer" To: , Subject: Antw: [SQL] Partial Search Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Disposition: inline Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by hub.org id JAA08554 >>> 01.12.1999 15.07 Uhr >>> >> I am trying to do a query with a partial search but don't know the >> syntax. eg. I want the word 'buff' to find 'buffalo' in the variable >> 'city'. Can anyone give me an example? >> >>-- >>Cheers, >> >>Derek select * from table where city like 'buff%'; ------------------- Gerhard