UPDATE [MyTable] SET [Field1] = @Field1, [Field2] = @Field2, [Field3] = if Field4 is true then [Field3] else @Field3In other words if Field4 is true (it is a bit field) then I do not want to update Field3, but if Field4 is false then I want to update Field3 with the passed parameter for Field3.