Creating Data Sources from Filters

For each condition in your filter, select a field name, a comparison, and a value.

Asterisks (*) mark fields that can be searched efficiently. If the underlying table is very large, the filter will be much faster if it uses only these fields.

This comparison...	is true if...
contains	Selected field's value contains the given value somewhere within it.
does not contain	Field's value does not contain the given value anywhere within it.
equals	Field's value exactly equals the given value.
does not equal	Field's value does not equal the given value.
is less than	Field's value is less than the given value.
is less than or equal	Field's value is less than or equal to the given value.
is greater than	Field's value is greater than the given value.
is greater than or equal	Field's value is greater than or equal to the given value.
begins with	Field's value contains the given value as its initial characters.
ends with	Field's value contains the given value as its final characters.
is null	Field is empty – contains no value.
is not null	Field contains a value.

Note: The greater-than and less-than comparisons take into account the type of the field involved. A numeric comparison is done for numeric fields; an alphabetic comparison is done for alphabetic fields. Date fields are handled specially. See Specifying date and time values.

To add another condition to the list, change the drop-down at the right end from END to AND or OR. Enter left and right parentheses as needed.

You can remove a condition from the middle of a list by setting the Field drop-down list to --Select Field--.