Difference between revisions of "SQL Predicates"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 24: | Line 24: | ||
|[[BETWEEN PREDICATE|BETWEEN]]||Evaluate whether an expression is between two other expressions. | |[[BETWEEN PREDICATE|BETWEEN]]||Evaluate whether an expression is between two other expressions. | ||
|- | |- | ||
| − | |[[IN PREDICATE| | + | |[[IN PREDICATE|IN]]||Evaluate whether an expression matches one of a set of values. |
|- | |- | ||
|[[LIKE PREDICATE|LIKE]]||Evaluate whether an expression is like another expression | |[[LIKE PREDICATE|LIKE]]||Evaluate whether an expression is like another expression | ||
Revision as of 12:57, 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. |
