>Hi
>
>Can anyone tell me if there is much difference here.
>
>Example 1:
>
>

SELECT Table
>SCAN FOR Ref = lcRef
>     lnRecNo = RECNO()
>     SCATTER MEMVAR
>     m.Ref = lcNewRef
>     INSERT INTO Table FROM MEMVAR
>     GO lnRecNo
>ENDSCAN
>

>
>Example 2:
>
>

SELECT *;
>  FROM Table;
> WHERE Ref = lcRef;
>  INTO CURSOR Updates
>
>SELECT Updates
>SCAN
>     SCATTER MEMVAR
>     m.Ref = lcNewRef
>     INSERT INTO Table FROM MEMVAR
>ENDSCAN
>

>
>The reason I'm asking is because "Table" is going to grow rapidly when live and this will be accessed on a Server.
>
>What I'm trying to avoid is all the record hopping in the 1st example, but I may be wrong in my 2nd solution, could someone let me know if there's much difference.
>
>Thanks
>Kev

Why not

REPLACE Ref WITH lcNewRef ALL FOR Ref=lcRef IN Table

The FOR clause must be Rushmore optimizable...