Filter Builder comparison operators

When you use the Filter Builder in basic mode, the Comparator field contains these comparison operators.

The operators are described in the following table.

Table 1. Comparison operators in the basic mode of the Filter Builder
Operator	Description
=	Tests for equality.
`<>` `!=`	Tests for inequality.
`<` `>` `<=` `>=`	Tests for greater than (`>)`, less than (`<`), greater than or equal to (`>=`) or less than or equal to (`<=`). These operators perform case-sensitive string comparisons. In standard ASCII case-sensitive comparisons, upper case letters precede lower case letters.
`[not] like`	The `like` operator performs string comparisons. The string following the `like` operator, which can be the result of a regular expression, is the pattern to which the column expression is compared. A regular expression can include regular expression pattern-matching metacharacters. The `not` keyword inverts the result of the comparison.