SQL Predicates

From Recital Documentation Wiki
Revision as of 15:22, 29 October 2009 by Helengeorge (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.