They both will work in VFP9 and MS SQL Server

>>

>>* Update
>>UPDATE table SET ... FROM table JOIN cursor ON table.pk = cursor.pk
>>* Insert
>>INSERT INTO table SELECT * FROM cursor
>>

>
>Thank you very much. I didn't know you can do that.