>I have a table with three fields, including one logical. I want to change the logical to .T. for every record that contains a unique entry. I've tried REPLACE MyTABLE.FIELD3 WITH .T. FOR (SELECT DISTINCT FIELD2 FROM MyTABLE) but I get a "Function name is missing )." What am I doing wrong?

Why not do a IIF(this,.t.,.f.) as my_field in your select segment? Then you let SQL do the work on the front end.

__Stephen