Hi,
try this sp
create procedure XYZ (@A int)
as
begin
1) Select * from table
where
and @a is null or @a = ''
2) Select * from table
where
and @a is not null or @a ''
3) Select * from table
where /*col1*/ = (case when (@A is null) or( @a = '') then Col1 else @a end)
END
ARUN SAS