Using Operators

Logical operators for defining filters support standard SQL wildcards, including “%” and “_”.

Table 117. Logical Operators for Defining Filters

Operator

Description

Equal (=)

Retrieves records where the filtered item equals the specified value(s).

Not Equal (<>)

Retrieves records where the filtered item does not equal the specified value(s).

Less Than (<)

Retrieves records where the filtered item is less than the specified value(s).

Less or Equal (<=)

Retrieves records where the filtered item is no greater than the specified value(s)

Greater Than (>);

Retrieves records where the filtered item is greater than the specified value(s).

Greater or Equal (>=);

Retrieves records where the filtered item is no less than the specified value(s)

Begins With

Retrieves records where the filtered item begins with the specified value(s) up to and including the end value.

Contains

Retrieves records where the filtered item contains the specified value(s) regardless of location.

Ends With

Retrieves records where the filtered item ends with the specified value(s).

Like (with wildcards)

Retrieves records where a text string is displayed and reflects the placement of the specified value(s).

For example, Name Likes_ would retrieve records for all employees whose names have the letters Ze followed by one character at the end

Is Null

Retrieves records where the filtered item has no value; for example a field in which no data has been entered.

Between

Retrieves records where the value of the filtered item lies between (and does not equal) the specified values.

Not (with operator)

Negates the operator it precedes, reversing the results of the equation

Note:

Text strings are evaluated differently among database systems, and are often case-sensitive (that is, “RED”, “Red” and “red” may not be equivalent in comparison). Text characters are generally valued in ascending order (0 1... 9 A B C... Z a b c... Z.), so that “A” is less than “a” in string comparisons, and strings beginning with numbers are considered “less” than strings beginning with alphabetic characters. See your administrator for specific information.