It's definitely cleaner to do it all with boolean logic in the where clause.

For example, assuming you've got defaults of '' for character params and NULL for @DOB:

WHERE (SURNAME =...

Thank you! That is very slick.

Thanks for your help... I think I've found a solution!

Next question: I was able to restore one instance of my live environment to my test box with no issues...