Difference between revisions of "SQL Predicates"
From Lianjapedia
Yvonne.milne (Talk | contribs) m (1 revision: SQL) |
Yvonne.milne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Special operators | Special operators | ||
| − | |||
==See Also== | ==See Also== | ||
[[SQL INSERT|INSERT]], [[SQL SELECT|SELECT]], [[SQL UPDATE|UPDATE]] | [[SQL INSERT|INSERT]], [[SQL SELECT|SELECT]], [[SQL UPDATE|UPDATE]] | ||
| − | |||
==Description== | ==Description== | ||
Predicates are special operators. They are used to evaluate an expression and return True (.T.), False (.F.) or Unknown (.NULL.). | Predicates are special operators. They are used to evaluate an expression and return True (.T.), False (.F.) or Unknown (.NULL.). | ||
| − | |||
| − | |||
{| class="wikitable" | {| class="wikitable" | ||
Revision as of 12:19, 10 February 2012
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. |
