>>I think I should be able to use IIF() to update only when the parameter passed in is not null.
>
>You can build the update statement based on the new values, and simply not include those which are null or empty.

Thanks, but that's what I wanted to avoid. Using one statement with the IIF() does exactly what I want.