Auditor Help:

Comparison Operators

Comparison operators test whether or not two expressions are the same. Comparison operators can be used on all expressions except expressions of the text, ntext, or image data types.

= (Equals) Setting value is equal to the threshold value.
> (Greater Than) Setting value is greater than the threshold value.
< (Less Than) Setting value is less than the threshold value.
>= (Greater Than or Equal To) Setting value is greater than or equal to the threshold value.
<= (Less Than or Equal To) Setting value is less than or equal to the threshold value.
!= (Not Equal To) Setting value is not equal to the threshold value.
!< (Not Less Than) Setting value is not less than the threshold value.
!> (Not Greater Than) Setting value is not greater than the threshold value.

Logical Operators

Logical operators test for the truth of some condition. Logical operators, like comparison operators, return a Boolean data type with a value of TRUE or FALSE.

BETWEEN Setting value is within the specified range (greater than the first value, less than the second).
NOT BETWEEN Setting value is not within the specified range.
IN Setting value is equal to one of the provided list of expressions (some attribute is equal to Value1 OR Value2... OR ValueN).
IS Setting value is equal to a string value, such as NULL.
NOT IN Setting value is not equal to one of the provided list of expressions.
WITHIN Setting value is equal to any of the results returned (some attribute is equal to Value1 AND Value2 AND... AND ValueN where any Value can contain a wildcard expression, such as %).
NOT WITHIN Setting value is not equal to any of the results returned.
LIKE Setting value matches the provided pattern.
NOT LIKE Setting value does not match the provided pattern.
NULL Setting value is NULL.
NOT NULL Setting value is not NULL.
AND Returned as TRUE if both Boolean expressions are TRUE.
OR Returned as TRUE if either Boolean expression is TRUE.
NOT Returned as the first expression is TRUE, UNLESS the second is TRUE.

Helpful Hint Tip: Only one criteria can be defined for any single attribute. For this reason, using AND between two statements that do not return the same attribute will return no results.