Comparison Operators and Wildcards


Using Comparison Operators in your report field ranges allows you to precisely define the information that appears on your reports. These operators may also be used to filter record listings more precisely.


% (stands for one or more characters)

For example, to query for all id's beginning with the characters TJ, you would enter TJ%. A wildcard may be inserted at the beginning, middle or end of a text string (e.g., all accounts ending with the characters 2003 would be specified as %2003).

The wildcard can also be used in a date range field. For example, to include all dates in the month of April, 2003 you would enter 2003-04%.

Comparison Operators
>  (Greater Than)
<  (Less Than)
>=  (Greater Than or Equal To)
<= (Less Than or Equal To)

For example, <abcde means that the field value must be less than abcde to appear in the list or report.

=  (Equal)

To query for blank fields, enter a filter line containing only = (the equal sign). Entering no operator is equivalent to preceding the value with =. For example, entering RT567 in a filter is equivalent to entering =RT567.

!  (Not)

This is the NOT operator. For example, !> (not greater than) is equivalent to <= (less than or equal to). The ! may also precede a range so that !ddd_fff will include all values of the field except those in the range ddd to fff.

~ (Global Not)

The tilde (~) is also a NOT operator. When the first character is a ~ the rest of the filter indicates which records to exclude. For example, ~a,p,m will include all values except a, p or m.

<>  (operator)

This is synonymous with ! or !=. You may query for non-blank fields by entering a query line containing only !, !=, or <>.

If the entered query clause contains commas (to make an OR query) then the above operators may be applied to each sub-field. For example, the following two entries select values outside of a range and are equivalent: