I would like to write a "conditional" update statement, something like this:

UPDATE MyTable
SET    field1 = @field1,
       field2 = IIF(LEN(@field2)>0, @field2, field2),
       field3 = @field3
WHERE  field4 = @field4

To put this into words I want to update field2 only if the passed @field2 (nvarchar) parameter is non-empty string.

Is the above syntax the best syntax to use for this, or is there a better way?

Thanks,
Einar