UPDATE [MyTable] SET [Field1] = @Field1, [Field2] = @Field2, [Field3] = CASE WHEN [Field4] THEN [Field3] ELSE @Field3 END>I think the answer to this is really simple but right now I cant see the forest for all the trees
>UPDATE [MyTable] >SET [Field1] = @Field1, > [Field2] = @Field2, > [Field3] = if Field4 is true then [Field3] else @Field3 >>