|
<< Click to Display Table of Contents >> Navigation: General Functions > Conditions > Operands |
Conditions use operands to compare various fields to a value. The available operands are defined as follows:
Operand |
Behavior |
= |
The value in the selected field and the value entered will be compared. The comparison will result in true if both are equal. |
<> |
The value in the selected field and the value entered will be compared. The comparison will result in true if they are not equal to each other. |
< |
The value in the selected field and the value entered will be compared. The comparison will result in true if the value in the selected field is less than the value entered. |
> |
The value in the selected field and the value entered will be compared. The comparison will result in true if the value in the selected field is greater than the value entered. |
>= |
The value in the selected field and the value entered will be compared. The comparison will result in true if the value in the selected field is greater than or equal to the value entered. |
<= |
The value in the selected field and the value entered will be compared. The comparison will result in true if the value in the selected field is less than or equal to the value entered. |
Is Like |
Returns true if the value entered is found anywhere within the value in the selected field. |
Is Not Like |
Returns true if the value entered is not found anywhere within the value in the selected field. |
Is In |
Returns true if the value in the selected field is contained within the comma-separated list of values entered. |
Is Not In |
Returns true if the value in the selected field is not contained within the comma-separated list of values entered. |
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. Note, the entered value (if any) is not used. |
Is MOD137 (9) |
Returns true if the value in the selected field is MOD137 compliant and is exactly 9 digits long. Note, the entered value (if any) is not used. |
Is MOD137 (10) |
Returns true if the value in the selected field is MOD137 compliant and is exactly 10 digits long. Note, the entered value (if any) is not used. |
Is MOD137 (11) |
Returns true if the value in the selected field is MOD137 compliant and is exactly 11 digits long. Note, the entered value (if any) is not used. |
Starts with ... |
Returns true if the value in the selected field starts with the value entered. |