>>>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.
The example statement had no ";" at the end of line, so I assumed this was what you were sending to the server.
One iif() per field? The amount of checking is pretty much the same, just fewer lines.