>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?