Format

      { value-expr1 [CASE_SENSITIVE] operator value-expr2 }
      { condition-clause                                  }
      { containing-clause                                 }
      {                                                   }
      { matching-clause                                   }
      { missing-clause                                    }
      { starting-with-clause                              }
      {                                                   }

1  –  Parameters

1.1  –  value-exprN

    N = value-expr1 or
    N = value-expr2

    Specifies a value. A value expression can consist of any of
    the following: character string literals, numeric literals, or
    arithmetic, concatenated, or statistical expressions. If either
    value expression in a condition evaluates to null, the entire
    condition evaluates to null.

1.2  –  operator

    Specifies a mathematical relational operator. See the
    mathematical relational operators in relational_operators help topic.

1.3  –  condition-clause

               { ALPHABETIC           }
               { ALPHABETIC_LOWER     }
               { ALPHABETIC_UPPER     }
               { EMPTY_FIELD          }
               { FULL_FIELD           }
    field-expr { NUMERIC              }
               { NOT ALPHABETIC       }
               { NOT ALPHABETIC_LOWER }
               { NOT ALPHABETIC_UPPER }
               { NOT EMPTY_FIELD      }
               { NOT FULL_FIELD       }
               { NOT NUMERIC          }

    Specifies whether a field expression satisfies the specified
    condition.

    The product using CDO evaluates a condition clause as true if
    the field expression satisfies the condition specified. The
    field expression specifies the name of a field in the database,
    consisting of a field name and a directory name or context
    variable.

    When you use the keyword NOT, the product using CDO evaluates
    the clause as true if the field expression does not satisfy this
    condition.

1.4  –  containing-clause

    value-expr1 CASE_SENSITIVE { CONTINING      } value-expr2
                               { NOT CONTAINING }

    Specifies whether a value expression contains a second value
    expression. This operation is not case sensitive unless you
    specify the CASE_SENSITIVE keyword.

    When you use the keyword NOT, the product using CDO evaluates the
    clause as true if the first string expression does not contain
    the string that the second string expression specifies.

1.5  –  matching-clause

    value-expr CASE_SENSITIVE { MATCHING     } match-expr
                              { NOT MATCHING }

    Specifies a relational clause that tests for substring matches.
    By using wildcard characters, you can specify the position of the
    substring. This operation is not case sensitive.

    The product using CDO evaluates a MATCHING clause as true if
    match expression, the second expression, matches a substring of
    the first expression. Specify the match expression in quotation
    marks.

    When you use the keyword NOT, the product using CDO evaluates
    the clause as true if the second expression does not match a
    substring of the first value expression.

1.6  –  missing-clause

    { field-expr  }  { MISSING     }
    { record-expr }  { NOT MISSING }

    Specifies whether a field or record expression is null. The
    product using CDO evaluates a MISSING clause as true if the
    record or field expression is null.

    Specifies the name of a field or record in the database,
    consisting of a directory name or a field or record name and a
    context variable.

    When you use the keyword NOT, the product using CDO evaluates the
    clause as true if the record or field expression is not null.

1.7  –  starting-with-clause

    value-expr1 CASE_SENSITIVE { STARTING WITH     } value-expr2
                               { NOT STARTING WITH }

    Specifies whether the first characters of a value expression
    match the characters of a second value expression. This operation
    is case sensitive.

    The product using CDO evaluates a STARTING WITH clause as true
    if the first characters of the first string expression match the
    characters in the second string expression.

    When you use the keyword NOT, the product using CDO evaluates the
    clause as true if the first string does not contain the string
    that the second string expression specifies.

    If either value expression in a condition evaluates to null, the
    condition evaluates to null.

2  –  Description

    A conditional expression, sometimes called a Boolean expression,
    represents the relationship between two value expressions. A
    conditional expression returns a value of true, false, or null
    (missing).

    Conditional expressions consist of value expressions and
    relational or logical operators.

    You can use conditional expressions in CDO as objects for the
    WITH clause or VALID IF clause of the record selection expression
    or the VALID IF clause in field definitions.