Difference between revisions of "SQL Predicates"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) m (Predicates moved to SQL Predicates) |
Yvonnemilne (Talk | contribs) |
||
| Line 22: | Line 22: | ||
!Predicate||Description | !Predicate||Description | ||
|- | |- | ||
| − | |[[BETWEEN | + | |[[BETWEEN Predicate|BETWEEN]]||Evaluate whether an expression is between two other expressions. |
|- | |- | ||
| − | |[[IN | + | |[[IN Predicate|IN]]||Evaluate whether an expression matches one of a set of values. |
|- | |- | ||
| − | |[[LIKE | + | |[[LIKE Predicate|LIKE]]||Evaluate whether an expression is like another expression |
|- | |- | ||
| − | |[[NULL | + | |[[NULL Predicate|NULL]]||Evaluate whether an expression is equal to .NULL. |
|- | |- | ||
|} | |} | ||
Revision as of 15:45, 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. |
