>>You would think, FoxPro would be smart enough to find the record with the Key, then check for conflicts... rather than just building such an ungly update statement.
>>
>>Perhaps someone close could mention this to Randay Brown or Calvin Hasia... I
>am sure they could fix it!
>>
>>BOb
>
>
>Thanks for the explanation.
>

So did making the WHERE type change fix your performance problem?

BOb