This is a great article on the best way to build store procedures when you have a requirement for variable clauses on your where statements (e.g. say search for an order by name or order date). Its pretty damn good!
Dynamic Search Conditions in T-SQL
Neil