Relational and Logical Expressions

A logical expression or relational expression returns TRUE, FALSE, or UNKNOWN.

The general patterns are:

expression comparison_operator [any | all] expression
expression [not] in expression 
[not]exists expression 
expression [not] between expression and expression
expression [not] like "match_string" [escape "escape_character "]
not expression like "match_string" [escape "escape_character "]
expression is [not] null
not logical_expression
logical_expression {and | or} logical_expression