DTRHELP.HLB  —  Boolean Expressions
       A Boolean expression is the logical representation of a
       relationship between value expressions. The value of a Boolean
       expression is either true or false. When dealing with relational
       sources, the value of a Boolean expression is either TRUE, FALSE,
       or UNKNOWN according to SQL/Services standards. The UNKNOWN
       boolean value may result if either value expression in a Boolean
       expression is null.

       You can use Boolean expressions in the following DEC DATATRIEVE
       clauses and statements:

       o  WITH clause in a record selection expression

       o  WITH clause in a SELECT statement

       o  IF clause of an IF-THEN-ELSE statement

       o  IF clause of an IF-THEN-ELSE value expression

       o  CHOICE statement

       o  CHOICE value expression

       o  VALID IF clause in a record definition

       o  WHILE statement

       The DEC DATATRIEVE CHOICE and IF-THEN-ELSE value expressions, and
       the CHOICE and IF-THEN-ELSE statements can contain an additional
       ELSE clause to support the UNKNOWN boolean value.

       Boolean expressions consist of value expressions, relational
       operators, and Boolean operators. Relational operators control
       the comparison of value expressions. Boolean operators enable you
       to join two or more Boolean expressions and to reverse the value
       of a Boolean expression. All Boolean expressions contain value
       expressions and relational operators, and some contain Boolean
       operators.
Additional Information: explode extract
Relational Operators Boolean Operators
Close Help