SQL Predicates
From Recital Documentation Wiki
Revision as of 15:32, 13 March 2009 by Yvonnemilne (Talk | contribs)
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. |
