>> Try this...
>> SELECT GRUPOS
>> REPLACE COD_GRU WITH ALLT(COD_GRU)
>>
>> or (but I've heard there are problems with this)
>>
>> REPLACE COD_GRU WITH ALLT(GRUPOS.COD_GRU) IN GRUPOS
>>
>> HTH
>
>scuse me. What kind of problems. I've used this quiet often without
>problem.
>
>Marc

Hi Marc,

You may run into problems if you forget to SELECT the appropriate Alias before issuing the REPLACE command - even if you specify the alias name like:

REPLACE ALIAS.field WITH ....

If the Alias is not on the current work area the results could be unpredictable.

Renato