Hi

select .....

where (ZWPSSN=@sn or @SN='all')

and (lastname like '%' + @ln + '%' or @ln='All')

and (firstname like '%' + @fn + '%' or @ln='All')

Give the user the select of...