#### Selecting records using date/number/character combinations

These formulas simply "mix and match" formulas from the categories above.

`"C" in {file.FIELD}[1] and Month({file.DATE}) in [1,4]`

Selects those records in which the value in the {file.FIELD} field begins with "C" and the month is either January or April. For example, if this kind of formula was used with an order database, you could be asking for a report showing all customers whose names begin with "C" and who placed orders in January or in April.

    "AOK" in {file.HISTORY}[3 to 5] and
    {file.OPENCRED} >= 5000
    Selects those records in which the {file.HISTORY} field shows the characters "AOK" as the 3, 4, and 5 characters and the {file.OPENCRED} field (the amount of available credit) is at least 5000.

These templates can be used as they are (with your own data), or they can be combined to create complex formulas.

Seagate Software, Inc. http://www.seagatesoftware.com Please send comments to: techpubs@seagatesoftware.com