What is the best way to set up the ability to refine search results using classic ASP and SQL server?<BR><BR>1. Is there a way to save the recordset in virtual memory and refine only based on the results "available/left over"?<BR><BR>2. Do I need to create a "temporary" table in SQL that holds the search results as the user refines his search?<BR><BR>3. Session Variable? -Probably a big memory problem, but thought I'd throw it out there as an option.<BR><BR>I appreciate any insight you can give me on allowing the user to refine search results by doing an infinite amount of secondary searches on the primary search results.<BR><BR>Thanks.