The following is the list of allowable relational operators. Each operator is given a description and two examples.
Relational Operators | Description | Example |
---|---|---|
< | Compares 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 |
> | Compares 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 |
<= | Compares 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 |
>= | Compares 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 |
= | Compares one identifier to another. Returns TRUE if the two Identifiers are EQUAL. | 01/01/2007=01/01/2007 Returns TRUE TRUE = FALSE Returns FALSE |
<> | Compares one identifier to another. Returns TRUE if the two Identifiers are NOT EQUAL. | SUNDAY <> FRIDAY Returns TRUE FALSE <> FALSE Returns FALSE |