PREDICATES

From Lianjapedia
Revision as of 10:10, 4 February 2013 by Helen.george (Talk | contribs)

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

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