Difference between revisions of "SQL Predicates"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Helengeorge (Talk | contribs) |
||
| (4 intermediate revisions by one user not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Special operators | Special operators | ||
| Line 22: | Line 15: | ||
!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. |
|- | |- | ||
|} | |} | ||
[[Category:Documentation]] | [[Category:Documentation]] | ||
| − | [[Category:SQL]] | + | [[Category:SQL|Predicates]] |
[[Category:Reference]] | [[Category:Reference]] | ||
Latest revision as of 15:22, 29 October 2009
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. |
