Let's review the FIND procedure option's syntax variations:
[BooleanValue :=] RecordName.FIND ( [Which] )
The [Which] parameter allows you to specify which record is searched for, relative to the defined key values. The defined key values are the set of values currently in the fields of the active key in the memory-resident record of the RecordName table.
The following table lists the Which parameter options and prerequisites:
The second table lists the FIND options, which are specific to SQL Server, as follows:
For all FIND options, the results always respect the applied filters.
The FIND('-') procedure is sometimes used as the first step of reading a set of data, such as reading all of the sales invoices for a single customer. In such a case, the NEXT procedure is used to trigger all subsequent data reads after the sequence is initiated with FIND('-'). Generally, FINDSET should be used...