SAND CDBMS SQL Reference Guide
SAND CDBMS SQL Database Objects and Language Elements


Previous Topic:
Value Expressions
Chapter Index
Next Topic:


Other SAND CDBMS SQL Language Elements

Boolean Expressions (Search Conditions)

Boolean value expressions are used in SAND CDBMS SQL to specify search conditions that can be used in a variety of SQL statements, including SELECT, UPDATE, and DELETE statements. These expressions use various predicates to test a particular operand (for example, the contents of a column) for membership in a specified set of values. If the operand satisfies the condition, it is TRUE; if it does not satisfy the condition, it is FALSE. A null value can force a Boolean expression to evaluate to UNKNOWN.

For the syntax and descriptions of the different predicates used in Boolean expressions, consult Selection Criteria for WHERE and HAVING Clauses.