Difference between revisions of "Relational Operators"

From Recital Documentation Wiki
Jump to: navigation, search
 
(One intermediate revision by one user not shown)
Line 47: Line 47:
  
  
In SQL mode (SET SQL ON or embedded EXEC SQL statements), the following wildcard characters are available:
+
In SQL statements, the following wildcard characters are available:
  
  
Line 58: Line 58:
 
|-
 
|-
 
|}
 
|}
 +
  
 
Note: For FoxPro compatibility reasons, wildcard pattern matching is not available when [[SET COMPATIBLE]] is set to FOXPRO/FOXBASE/FOXPLUS/VFP.
 
Note: For FoxPro compatibility reasons, wildcard pattern matching is not available when [[SET COMPATIBLE]] is set to FOXPRO/FOXBASE/FOXPLUS/VFP.

Latest revision as of 16:01, 5 July 2011

The following Relational Operators are supported in the Recital/4GL:


Operator Operation
= Equal To
== Exactly Equal To / Matches Pattern
<> Not Equal To
!= Not Equal To
# Not Equal To
> Greater Than
>= Greater Than or Equal To
< Less Than
<= Less Than or Equal To
$ Substring is Contained In
| Contains Substring


The Relational Operators are always evaluated from left to right.

The following ’wildcard’ characters can be used for == pattern matching:


Character Action
? Matches any one character
% Matches any one character
* Matches zero or more characters


In SQL statements, the following wildcard characters are available:


Characters Description
_ Matches any one character
% Matches zero or more characters


Note: For FoxPro compatibility reasons, wildcard pattern matching is not available when SET COMPATIBLE is set to FOXPRO/FOXBASE/FOXPLUS/VFP.


Example

cSTR1 = [Welcome to the Recital/4GL]
? "Recital" $ cSTR1
.T.
 
cSTR2 = [Welcome]
// Compares to the end of cSTR2
? cSTR1 = cSTR2
.T.
 
// Compare contents & size
? cSTR1 == cSTR2
.F.