Message-Id: <9511061652.AA16635@aztec.lib.utk.edu>
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Date: Mon, 06 Nov 1995 11:53:44 -0500
To: postgres95@postgres.Berkeley.EDU
From: blape@utk.edu (Bryon S. Lape)
Subject: word/sub-word
Resent-To: owner-postgres95
Resent-Date: Mon, 06 Nov 95 08:53:50 -0800
Resent-From: pglite
Resent-XMts: smtp

        For reasons that are stupid, I need to be able to let users of Web
forms that search our Postgres95 databases have an option to search for a
whole word or sub-word.  For instance, is somone give "SONG" as a title,
then for whole word match, things like "SONGS" and "SONGBOOK" would not
return (they would for sub-word).  My question is, how do I form these
requests?  Currently, I use LIKE '%user_word%', which works fine for
sub-word.  Any help would be highly appreciated.


bryon
--------------------------------------------------------------------------
No matter the law, the will is still free.

Bryon S. Lape
e-mail: blape@utk.edu  WWW:http://aztec.lib.utk.edu/~bryon/