Operator

Definition

<

Less than.  Returns true if A is less than B.  If either A or B is non-numeric, then the comparison is done between two strings, and the result will be true if the string A is less than the string B.  (String comparisons will often differ from numeric comparisons).  The string comparison is case sensitive.

<=

Less than or equal to.  Returns true if A is less than or equal to B.  If either A or B is non-numeric, then the comparison is done between strings. The string comparison is case sensitive.

<>

Not equals.  Returns true if A is not equal to B.  If either A or B is non-numeric, then the comparison is done between two strings.  A case insensitive comparison is performed.

=

Equals.  Returns true if A is equal to B.  If either A or B is non-numeric, then the comparison is done between two strings.  A case insensitive comparison is performed.

>

Greater than.  Returns true if A is greater than B.  If either A or B is non-numeric, then the comparison is done between two strings, and the result will be true if the string A is greater than the string B. The string comparison is case sensitive.

>=

Greater than or equal to.  Returns true if A is greater than or equal to B.  If either A or B is non-numeric, then the comparison is done between strings. The string comparison is case sensitive.

Is In

Returns true if operand A is contained within a list of items defined by operand B.  Operand B is a comma-separated list of values (values that do not contain commas).  If A is found within the list, true is returned.  NOTE:  There can be no spaces in front of or after items in the operand B list.  Otherwise, A will not be matched to a member of the list of B and false will be returned.

Is Like

Returns true if operand B is contained within operand A (B is a substring of A).  The comparison is case insensitive.

Is Not In

Returns true if operand A is not contained within a list of items defined by operand B.  Operand B is a comma-separated list of values (values that do not contain commas).  If A is not found within the list, true is returned.  NOTE:  There can be no spaces in front of or after items in the operand B list.  Otherwise, A will not be matched to a member of the list of B and true will be returned.

Is Not Like

Returns true if operand B is not contained within operand A (B is not a substring of A).  The comparison is case insensitive.

Is MOD137

Returns true if the value in the selected field is MOD137 compliant, regardless of length.

Is MOD137 (8)

Returns true if the value in the selected field is MOD137 compliant and is exactly 8 digits long.

Is MOD137 (9)

Returns true if the value in the selected field is MOD137 compliant and is exactly 9 digits long.

Is MOD137 (10)

Returns true if the value in the selected field is MOD137 compliant and is exactly 10 digits long.

Is MOD137 (11)

Returns true if the value in the selected field is MOD137 compliant and is exactly 11 digits long.

Starts with ...

Returns true if the value in the selected field starts with the value entered.