>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.