Try This...

CREATE PROCEDURE sp_Modify_Where

 @Open  bit = 1

AS

select

 *

from

 mytable

where

 (@Open = 1 AND closed_date is null) OR

 (@Open = 0 AND closed_date is not null)

Edwin Stephenraj.