>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
Peter Cortiel