I am trying to understand the meaning of what you said. Do you mean that in MS SQL Server the value of MYFLD1 - if used twice - will still be the old/original value?
>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).
>>
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham