Using ranges in queries

A range is defined by using a combination of less than (<) and greater than (>) relational operators between theand logical operator or theor logical operator.

To query of a range of data, use the Query Window.

Operator Usage Examples
AND
and
>value and <value field_name > lesser_value and field_name < greater_value
For example, open.time>'09/15/2008' and open.time<'09/27/2008'

The and logical operator is not case-sensitive.

You can use (&) as a shortcut for the and logical operator.

OR
or
<value or >value field_name < lesser_value or field_name > greater_value
For example, open.time<'09/15/2008' or open.time>'09/27/2008'

The or logical operator is not case-sensitive.

You can use (|) as a shortcut for the or logical operator.

Related topics

Logical operators
Relational operators
Retrieving records by using the record list method
Retrieving records using the Query window method