You can do it in one update

UPDATE MYTABLE SET MYFLD1 = MAX(MYFLD1 - nValue1) + nValue2 WHERE Pk = nPkValue

>
>I need to have an UPDATE command that will update the same field twice. For example,
>
>

>UPDATE MYTABLE SET MYFLD1 = MAX(MYFLD1 - nValue1), SET MYFLD1 = MYFLD1 + nValue2 WHERE Pk = nPkValue
>

>
>How does VFP and SQL Server process this? Can I rely that the field MYFLD1 will be update in the order it appears in the UPDATE expression? Or is it better to have 2 UPDATE statements, in order to make sure that the order of update is correct (as far my need).
>
>Thank you in advance for any help.