I write the Where clause using something like

Code:
(@Param1 Is Null Or Field1 = @Param1)  And
(@Param2 Is Null Or Field2 = @Param2)  And
(@Param3 Is Null Or Field3 = @Param3)