Date:         Thu, 19 Sep 2002 10:10:22 -0400
Reply-To:     Vaishali Joshi <vjoshi73@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Vaishali Joshi <vjoshi73@YAHOO.COM>
Subject:      doing a kew word search

Hello,
I have an oracle table called history_text with a LONG datatype column
called History_doc.  There is another column called IDNUM (Primary Key).
I have a list of 40 keywords.  Basically I want to pull out idnums whose
history_doc contain any of these 40 keywords.  I also need to keep a track
of all the words found.  I am trying to come up with the most efficient way
of solving this problem.  Right now I have set up a text file with 40
select statements for each keyword and that seems highly inefficient.
Has anyone does analysis similar to this?
Any suggestions will be appreciated.
Thank you,