>
>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.
UPDATE MyTable SET Field3 = .T. WHERE NOT EXISTS( SELECT * FROM MyTable t2 WHERE MyTable.Field2 = t2.Field2 AND t2.Field3)
Alex
Alex