Hi Lina,

You can use case when statement for your reqirment.

declare @parm smallint

set @parm =10

select * from table1 where id = case @parm  when null then null else @parm end

thanks

sahu