Just to clarify: IndexSeek() will not actually move the record pointer unless you specify that you want it to. However the logic still holds, it will 'find' the first occurance including deleted records unless you set delete on.

>Hi Lance,
>
>In cases where duplicate matches exist, seek functions will move the record pointer to the first occurance in the file. If you don't want to land on a deleted record then set delete on.
>
>>I am using the indexseek() command to check for duplicate records. Currently, I have a deleted record with a field value of 'C'. I have another record that is not deleted and has a field value of 'C1'. If I rename 'C1' to 'C' the indexseek() command causes the deleted record to be found. Can somebody tell me why this happens and how to get around the problem?
>>
>>I have set delete='off' and set exact='on'.
>>
>>Thanks,
>>
>>Lance