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