Would this work in a scenario where you are searching on up to 40 or 50 criteria? I'm trying to design a super fast search of MLS (real estate, multiple listing) data. Currently we have a table with like 50 rows and we use dynamic SQL. ANy suggestions on how I could do this the way you suggested? Would there be a table for each criteria? IE: A number of bedrooms table, number of baths table, price table, pool view table, etc. etc..