Stored procedure null check

Question

Hi,

 

  I have a situation in my SP.... 2 where conditions thre... one is mandatory and other is optional.

Please let me know if optional value is not null it should also be taken to condition ...if not it must  take one mandatory value for condition.

 

Thanks in advance