ODBC Search String format for FindFirst, FindLast, FindNext, FindPrev Methods

The search string has the following basic format:

<field> <operator> <value>

where,

<field> = name of a field in the database (see the Recordset.FieldList property)

<operator> = one of the conditional operators: < > <= >= <> = LIKE NOTLIKE

<value> = numeric data or quoted string.

Additionally, this format can be expanded to include AND and OR:

<field> <operator> <value> AND <field> <operator> <value>

<field> <operator> <value> OR <field> <operator> <value>

Examples:

FindLast(“Title = ‘Vice President’”)

FindFirst(“Branch = ‘Engineering’ AND Salary < 30000”)