>
>Yeah, it all needs some playing around usually.
>There also may be the different solutions with REPLACE, for example
>to build the temporary UNIQUIE index, then REPLACE ALL field3 with .t.
>

Hi Nick, :)

yes, ya right. There are a lot of ways to do that.
Here is one more solution:

UPDATE MyTable SET Field3 = .F.
* Or REPLACE ALL Field3 WITH .F.
UPDATE MyTable SET Field3 = .T. WHERE NOT EXISTS( SELECT * FROM MyTable t2 WHERE MyTable.Field2 = t2.Field2 AND t2.Field3)

Alex