Select database records

Use the select command to select records of interest. Use any combination of attributes. In list mode only, the primary key specification defaults to * (all records). In edit or delete modes, you must include the primary key in the select specifications. To be selected, records must match all selection criteria.

Select specifications remain in effect until the mode or table is changed. Until a command is processed, select specifications are added to previous specifications. After that, a new select specification replaces the previous ones.

To check the select specifications currently in effect, type:

@select ?

Comparison operators

Use these comparison operators with the select command:

• = equal

• <> not equal (!= also works)

• > greater than

• >= greater than or equal to

• < less than

• <= less than or equal to

• These operators can be used for date, numeric or text fields. Text comparison is based on ASCII values.

Wildcards

Wildcards, * and ?, may be used in text fields. * matches all characters; ? matches a single character.