PL/SQL and building a search engine

I am trying to build a small search engine via PL/SQL stored procedure. I guess my question is what is the best way to compare a string coming into the procedure with what exists in the database. For example: I am building a message posting web board. I want a user to be able to search for messages which may exist in a given topic. Therefore I would have them type in a keyword and then pass that keyword into the stored procedure. In the database I have a message_subject field and a message field. Now how could I compare the keyword that was passed into the search engine with the messages that exist in the database for that topic?

If answering this question, could you send response via email since I cannot check the newsgroup too many times during the day. Thanks.

--


**************************************

Bryan J. Gentile
Consultant
Business Data Services, Inc.
Glastonbury, CT  06033
Phone: (860) 633-3693 (ext. 3025)
Vmail: (ext. 6030)


**************************************