SEEK

    SEEK searches an indexed database file for the first record with an
    index key that matches the specified character string or number.  SEEK
    conducts a very rapid record search.

Syntax

    SEEK <exp>

Argument

    <exp> is an expression to be matched with an index key.

Usage

    SEEK searches the controlling index starting with the first key and
    proceeds until a match is found or there is a key value greater than
    the search argument.  If there is a match, the record pointer is
    positioned to the record number found in the index.  If SOFTSEEK is OFF
    (the default) and SEEK 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()
    only returns true (.T.) if there are no keys in the index greater than
    the search argument.