SQL Predicates
From Lianjapedia
Revision as of 11:22, 29 October 2009 by Helengeorge (Talk)
Purpose
Special operators
See Also
Description
Predicates are special operators. They are used to evaluate an expression and return True (.T.), False (.F.) or Unknown (.NULL.).
Predicate | Description |
---|---|
BETWEEN | Evaluate whether an expression is between two other expressions. |
IN | Evaluate whether an expression matches one of a set of values. |
LIKE | Evaluate whether an expression is like another expression |
NULL | Evaluate whether an expression is equal to .NULL. |