SQL Predicates

From Recital Documentation Wiki
Revision as of 12:57, 13 March 2009 by Yvonnemilne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

PREDICATES

Class

SQL Applications


Purpose

Special operators


See Also

INSERT, SELECT, UPDATE


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 PREDICATE|]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.