Received: from trends.net (clio.trends.ca [209.47.148.2])
	by hub.org (8.9.3/8.9.3) with ESMTP id JAA01843
	for <pgsql-sql@postgresql.org>; Wed, 1 Dec 1999 09:42:50 -0500 (EST)
	(envelope-from dpeczeniuk@aiming.net)
Received: from aim-sparc2.aiming.net ([207.219.104.27])
	by trends.net (8.8.8/8.8.8) with ESMTP id JAA24806
	for <pgsql-sql@postgresql.org>; Wed, 1 Dec 1999 09:14:19 -0500 (EST)
Received: from aiming.net (wstation1.aiming.net [207.219.104.18])
	by aim-sparc2.aiming.net (Post.Office MTA v3.5.3 release 223
	ID# 0-59592U500L2S100V35) with ESMTP id net
	for <pgsql-sql@postgresql.org>; Wed, 1 Dec 1999 09:15:08 -0500
Message-ID: <38452BB4.B7F32589@aiming.net>
Date: Wed, 01 Dec 1999 09:07:48 -0500
From: pez@aiming.net
Reply-To: pez@aiming.net
X-Mailer: Mozilla 4.7 [en] (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Partial Search
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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