The following is the list of allowable relational operators. Each operator is given a description and two examples.
| Relational Operators | Description | Example |
|---|---|---|
| < | Used to compare one Identifier to another. Returns TRUE if the Identifier on the left is LESS THAN the Identifier on the right. | 01/01/2007<01/31/2007Returns TRUE SUNDAY<SUNDAY Returns FALSE |
| > | Used to compare one Identifier to another. Returns TRUE if the Identifier on the left is GREATER THAN the Identifier on the right. | 01/01/2007>01/31/2007 Returns FALSE SUNDAY<SUNDAY Returns FALSE |
| <= | Used to compare one Identifier to another. Returns TRUE if the Identifier on the left is LESS THAN OR EQUAL TO the Identifier on the right. | 01/01/2007<=06/15/2005 Returns FALSE SUNDAY<=SUNDAY Returns TRUE |
| >= | Used to compare one Identifier to another. Returns TRUE if the Identifier on the left is GREATER THAN OR EQUAL TO the Identifier on the right. | 01/01/2007>=06/15/2005 Returns TRUE SUNDAY>=SUNDAY Returns TRUE |
| = | Used to compare one Identifier to another. Returns TRUE if the two Identifiers are EQUAL. | 01/01/2007=01/01/2007 Returns TRUE TRUE = FALSE Returns FALSE |
| <> | Used to compare one Identifier to another. Returns TRUE if the two Identifiers are NOT EQUAL. | SUNDAY <> FRIDAY Returns TRUE FALSE <> FALSE Returns FALSE |