BTW, in MS SQL Server any references to the columns of table that is updated point to old values.
I don't think it's the case in VFP.
>
>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).
>
--sb--