You're welcome.
>That's exactly what happened. Thanks.
>
>>It would happen if index on the cursor is set to bondky. The REPLACE will effectively change position of the record in the index causing behavior you describe. SET INDEX TO will fix it. Also it can be done with UPDATE command
>>
>>UPDATE curRedemptions ;
>> SET bondky = bond.ky ;
>> FROM curRedemptions JOIN bond ON bond.proj = curRedemptions.Project
>>
>>
--sb--