Brenda

Not having done this in VFP, I'm not sure but, does this work (i.e. I'm not sure that in VFP SQL you can put an SQL select in the Update's FilterCondition)?

UPDATE Customer ;
   SET No_Mail = .T.       && First posit them all as no mail

* Then set no_mail .F. (allow mail) for the first instance of each customer
* _____________
UPDATE Customer ;
   SET No_Mail = .F.;
   WHERE Customer.Name in ( Select DISTINCT Name from Customer)

HTH
Let me know, huh (or someone shoot me down - I haven't tried this)

Terry

>I have a table that can have multiple records per customer. The customer name is not unique. If there is an exact duplicate on cust_name I do not want to send them multiple mailings. I have a field no_mail that I want to set to .T. for any duplicate cust_name.
>
>Thanks
>
>Brenda