>In VFP yes ( field1 get the new value ), in MSSQL no ( because you can use a variable )
>
what do you mean???

This is what I would expect:

if I do :
update mytable set field1="AAA",field2=field1+"3333" where ....

I would want to have "AAA3333" in field 2

anything else would be illogical IMHO

Peter