You'll be able to do that in VFP9. Until than there's a kludge way as shown in Re: GATHER NAME vs APPEND Message #914947

>I want to use UPDATE command to update in DLWinniners table from TEMP table. The table structure is like this:
>

>DLWinners:  OrgCode C(5)
>            Code    C(5)
>            more fields...
>
>TEMP        Code    C(5)
>            CodeNew C(5)
>

>If DlWinners.OrgCode is found in TEMP.Code, I want to replace Dlwinners.code with TEMP.CodeNew. I know that this can be done very easily by establishing a relation between two tables. However, is it possible to do this using a single UPDATE command?
>
>Thanks.