Difference between revisions of "SQL Predicates"

From Recital Documentation Wiki
Jump to: navigation, search
m (Predicates moved to SQL Predicates)
Line 22: Line 22:
 
!Predicate||Description
 
!Predicate||Description
 
|-
 
|-
|[[BETWEEN PREDICATE|BETWEEN]]||Evaluate whether an expression is between two other expressions.
+
|[[BETWEEN Predicate|BETWEEN]]||Evaluate whether an expression is between two other expressions.
 
|-
 
|-
|[[IN PREDICATE|IN]]||Evaluate whether an expression matches one of a set of values.
+
|[[IN Predicate|IN]]||Evaluate whether an expression matches one of a set of values.
 
|-
 
|-
|[[LIKE PREDICATE|LIKE]]||Evaluate whether an expression is like another expression
+
|[[LIKE Predicate|LIKE]]||Evaluate whether an expression is like another expression
 
|-
 
|-
|[[NULL PREDICATE|NULL]]||Evaluate whether an expression is equal to .NULL.
+
|[[NULL Predicate|NULL]]||Evaluate whether an expression is equal to .NULL.
 
|-
 
|-
 
|}
 
|}

Revision as of 15:45, 13 March 2009

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