Re: PL/SQL and building a search engine

Bryan J. Gentile wrote:
>
> 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)
> **************************************
Hi,

take a look at the 'soundex'-function.

-- 
Regards

M.Gresz    :-)