IF (@Name is NULL)
 IF (@Address is NULL)
  IF (@Email is NULL)
   SELECT ...
     FROM TheTable
  ELSE
   SELECT ...
     FROM TheTable
    WHERE Email like @Email + '%'
 ELSE
  ...