>Hi Rich,
>
> How about opening the table twice. Use 1 table for scanning and the other for updating. Such as:
>

>SELECT 0
>USE mytable ALIAS lookuptable
>SET ORDER TO mykey
>
>SELECT 0
>USE mytable ALIAS updatetable AGAIN
>
>SELECT lookuptable
>
>SCAN
>    SELECT updatetable
>    LOCATE FOR mykey = lookuptable.mykey
>    IF FOUND()
>	REPLACE mykey WITH myupdatevalue
>    ENDIF
>    SELECT lookuptable
>ENDSCAN
>

>
>This would ensure that the next record scanned would be Ford instead of Turley, although Pepitone would be encountered after Mantle.
>
>Hope this helps,
>Gavin...
>

I appreciate the reply Gavin. I don't think it will fit in well in my application but I'll remember it in the future.

.......Rich