Difference between revisions of "SQL Predicates"
From Lianjapedia
Yvonne.milne (Talk | contribs) m (1 revision: SQL) |
|
(No difference)
|
Revision as of 04:17, 25 October 2011
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. |