In SQL, a Boolean value — either TRUE,
FALSE or UNKNOWN — is a truth value. A
Boolean value may be a <literal>, the value of a parameter or a host language
variable or the result of any expression or argument (including a possibly
qualified <Column name> or the result of an SQL predicate or search condition)
that evaluates to a truth value. Boolean values are stored in the Boolean <data
type>: BOOLEAN.
-
< Boolean literal >s
A <Boolean literal> is one of these three words: TRUE FALSE UNKNOWN Its <d... -
Boolean <data type>s
A Boolean <data type> is defined by a descriptor that contains one piece of... -
Boolean Operations
A Boolean value is compatible with, and comparable to, all other Boolean va... -
Table 9.1
Table 9.1: Truth Values for the Boolean IS Operator <<style class="underhea... -
Table 9.2
Table9.2: Truth Values for the Boolean AND Operator <<style class="underhea... -
Table 9.3
Table 9.3: Truth Values for the Boolean OR Operator <<style class="underhea...
