Difference between revisions of "SQL Predicates"

From Recital Documentation Wiki
Jump to: navigation, search
 
 
(5 intermediate revisions by one user not shown)
Line 1: Line 1:
=PREDICATES=
 
 
 
==Class==
 
SQL Applications
 
 
 
 
==Purpose==
 
==Purpose==
 
Special operators
 
Special operators
Line 22: Line 15:
 
!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.
 
|-
 
|-
 
|}
 
|}
 
[[Category:Documentation]]
 
[[Category:Documentation]]
[[Category:SQL]]
+
[[Category:SQL|Predicates]]
 
[[Category:Reference]]
 
[[Category:Reference]]

Latest revision as of 15:22, 29 October 2009

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.