FIND is included for backward compatibility. Use SEEK instead.

FIND moves the record pointer to the first record in the table whose index key matches the character expression expC. FIND requires the selected table to be indexed. The match with the index expression must be exact unless SET EXACT is OFF.

If a matching record is found, RECNO() returns the record number of the matching record, FOUND() returns true (.T.) and EOF() returns false (.F.).

If a match isn't found, RECNO() returns the number of records in the table plus 1, FOUND() returns false (.F.) and EOF() returns true (.T.).

If SET NEAR is ON and FIND is unsuccessful, the record pointer is positioned immediately after the closest matching record. If SET NEAR is OFF and FIND is unsuccessful, the record pointer is positioned at the end of the file. In either case, RECNO() issued with an argument of 0 returns the record number of the closest matching record.

Other Resources

Backward-Compatible Language Elements