I've been asked to create a search feature for a site using ASP/SQL Server 7 where the user can possibly select multiple search criteria from multiple fields as well as a AND/OR boolean option. It will work exactly like this page:<BR><BR>http://www.tclfm.com/ceos/search.htm <BR><BR>which is running on Filemaker. I've done this in the past by just checking for an empty value in every field and creating a SQL statement based on what the user selected. However, this is a real pain, doesn't run very quickly, and takes hundreds of lines of asp code based on what fields the user places a value in. There's got to be a better way: Sql Server full-text service? stored procedures? <BR><BR>any suggestions are appreciated.