>Renato,
>
>No, not quite (at least not in my experience).
>Yes, *your* example can lead to difficulties when the current selected area is at EOF(), but Marc's question has the "IN" clause included and I have never had a "surprise" with it coded.
>
>Cheers,
>Jim N

Hi Jim,

I've also never had problems when using the new "IN" clause - I was talking about the first example mentioned without it...

:-)
Renato

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