Modifiers
A mask that starts with ¬ (not) selects only those records that do not match the criteria. For example
¬ PAY1
skips all PAY1 records
and
¬ PAY*
skips all records that start with PAY, such as PAY1 or PAYROLL.
A mask that starts with > (greater than) selects only records that are higher than the entered value. For example
>PA
selects only records that began with a value greater than PA.
A mask that starts with < (less than), selects only records that are lower than the entered value. For example
<P
selects only records that began with a value less than P.
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*