ASP/database request for help

I am in the process of developing an ASP/VBScript search facility to enable web access to a (MS Access) relational database of image information. The user should be able to enter any number of search terms with matching items being returned and ranked in order of the number of search terms matched.

I have two possible solutions in mind:

1 - Construct an SQL query for each search term and join them together using UNION ALL so that items matching n terms get returned n times.

or

2 - Construct a single SQL query using IN to search a list of all the search terms then pattern matching the description field of the results against the search terms to award each a rank.

Which of the above strategies is best and is there another startegy that I should be considering? Received on Mon Jul 16 2001 - 23:25:25 CEST