Click above to get retro games delivered to your door ever month!

 FIND*
 Search an index for a specified key value
------------------------------------------------------------------------------
 Syntax

     FIND <xcSearchString>

 Arguments

     <xcSearchString> is part or all of the index key of a record to
     search for and can be specified either as a literal string or as a
     character expression enclosed in parentheses.  If an expression is
     specified instead of a literal string, FIND operates the same as SEEK.

 Description

     FIND is a database command that searches an index for the first key
     matching the specified character string and positions the record pointer
     to the corresponding record.

     If SOFTSEEK is OFF and FIND does not find a record, the record pointer
     is positioned to LASTREC() + 1, EOF() returns true (.T.), and FOUND()
     returns false (.F.).

     If SOFTSEEK is ON, the record pointer is positioned to the record with
     the first key value greater than the search argument and FOUND() returns
     false (.F.).  In this case, EOF() returns true (.T.) only if there are
     no keys in the index greater than the search argument.

     FIND is a compatibility command and not recommended.  Its usage is
     superseded entirely by the SEEK command.

 Examples

     .  These examples show simple FIND results:

        USE Sales INDEX Branch NEW
        FIND ("500")
        ? FOUND(), EOF(), RECNO()         // Result: .F. .T. 85
        FIND 200
        ? FOUND(), EOF(), RECNO()         // Result: .T. .F. 5
        FIND "100"
        ? FOUND(), EOF(), RECNO()         // Result: .T. .F. 1

 Files:  Library is CLIPPER.LIB.