RDOHELP72.HLB  —  Rel operators
    Permitted                  Relational Operation
    Symbols

    EQ =                        True if the two value expressions are
                                equal.

    NE <>                       True if the two value expressions are not
                                equal.

    GT >                        True if the first value expression is
                                greater than the second.

    GE >=                       True if the first value expression is
                                greater than or equal to the second.

    LT <                        True if the first value expression is less
                                than the second.

    LE <=                       True if the first value expression is less
                                than or equal to the second.

    BETWEEN                     True if the first value expression is
                                between the second and third or equal to
                                one of them.

    ANY                        True if the record stream specified by the
                               RSE includes at least one record. If you
                               add NOT, the condition is true if there are
                               no records in the record stream.

    MATCHING                   True if the second expression matches a
                               substring of the first value expression.
                               MATCHING uses these special characters:

                                   *  Matches any string
                                   % Matches any character

    MISSING                    True if the value expression is null.

    UNIQUE                     True if the record stream specified by the
                               RSE includes only one record. If you add
                               NOT, the condition is true if there is more
                               than one record in the record stream or the
                               record stream is empty.

    CONTAINING                 True if the string specified by the second
                               string expression is found within the
                               string specified by the first. Not
                               case sensitive.

    STARTING WITH              True if the first characters of the first
                               string expression match the second string
                               expression. Case sensitive.
Close Help