Whats the best way to approach a stored procedure that could have any type of where clause?<BR><BR>ie at the minimum, I want to "select fields from Table" and add any "where" clause I want (it may be dynamic) as part of the parameters passed. I may pass up to 20 criteria as part of the where clause, I may pass none.<BR><BR>Whats the best way and is there a URL I could view as well for good samples?