>>>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)
Thierry Nivelet
FoxinCloud
Give your VFP application a second life, web-based, in YOUR cloud
http://foxincloud.com/Never explain, never complain (Queen Elizabeth II)