advice on asp classic site search engine script for dynamicly generated catalog pages

[kingbitrat]

I am 'redoing' my web page that is built in asp classic. I want to add a site search engine. Many of my pages are generated dynamicly through a DSN to a ODBC with a access db on the back end. I want the search engine to be able to generate a "returned catalog item" if the user searchs on a word or words that contain the name, or other features associated with a catalog item. Am I stuck having to make a SQL query string, parse it and search throught the db? Is there 'free' or nearly free code snippets that can help me? All input greatly appreciated. TIA. :(

[netvizion]

.net magazine has a nice article on doing a site search in asp. Here is the URL:

http://www.netmag.co.uk/tutorials/default.asp?pagetypeid=2&articleid=11084&subsectionid=499&subsubsectionid=176

Source code is provided.