>>>>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.
>
>iif() or nvl()
>

>emp_middlename = nvl(?m.emp_middlename, emp_middlename)
>

Thanks, this is SQL Server that I am updating so I can't use NVL(), but I could use ISNULL().