Difference between revisions of "SQL Predicates"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) m (PREDICATES moved to Predicates) |
(No difference)
| |
Revision as of 15:32, 13 March 2009
PREDICATES
Class
SQL Applications
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. |
