Conditional where clauses imo are easily implemented using optional parameters in stored procs with an OR in the where clause for each field you're checking with the optional parameter.

i.e.

Create Procedure...