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.