Instead of Including FOR NOT DELETED() in your index, just make sure SET DELETED in ON when you run this code.
>There were three recs that were marked for deletion (all with fcCurId = "DUH"). After packing the table, the function seemed to work fine. How would that cause this problem?
>
>>>No there are no filters and the table has one index: UPPER(fcCurID) FOR .NOT. DELETED()
>>>
>>>>>Thanks in advance,
>>>>
>>>>How is the table ordered?
>>>>
>>>>Is there any filters on the table?
>>
>>Your sure that one record is not deleted?
Erik Moore
Clientelligence