If you don't want NULL change the REPLACE command to:
REPLACE group_code WITH client.group_code FOR FOUND('CLIENT')

>Select Policy
>Set Order to ssNumberTag in client
>Set Relation to ssnumber Into client
>Replace all group_code with client.group_code
>
>This will do the same. Although, it will replace group_code with null if no record is found in client.
>
>>> Hi, <
>>> I have two tables one client the other policy. <
>>> What I'm trying to do is replace a field in my policy tabl with <
>>> a field in my client table. <
>>> the code syntax is as follows: <
>>
>>> Select policy <
>>> <
>>> replace group_code with client.group_code ; <
>>> for seek(policy.ssnumber,"client","ssnumberTag") <
>>> <
>>> Again, new to VFP6.0 but getting it fast. Does anyone have <
>>> have anotherway of doing the same thing ? If possable, a code <
>>> sample please. I was thinking of using a replace statment, <
>>> but didn't know how to express it in code. <
>>> thanks John <