Relational Operators

See Also

Relational operators work with all data types and return a Logical value. The following table lists the relational operators.

Relational Operators

Operator Action Code 
<
 Less than 
? 23 < 54
 
>
 Greater than 
? 1 > 2 
=
 Equal to 
? cVar1 = cVar
 
<>, #, !=
 Not equal to 
? .T. <> .F.
 
<=
 Less than or equal to 
? {^1998/02/16} <= {^1998/02/16}
 
>=
 Greater than or equal to 
? 32 >= nHisAge
 
==
 Character string comparison 
? status == "Open"

The == operator can be used when an exact comparison of character strings is needed. If two character expressions are compared with the == operator, the expressions on both sides of the == operator must contain exactly the same characters, including blanks, to be considered equal. The SET EXACT setting is ignored when character strings are compared using ==. See SET EXACT for more information on using the == operator to compare character strings.

You can also use the equal to (=) operator in Visual FoxPro 6.0 to determine if two object references refer to the same object. The following example demonstrates a simple usage:

CLEAR ALL
X = CREATEOBJECT('Form')
Y = CREATEOBJECT('Form')
? X = Y  && Displays false (.F.)
Z = X
? X = Z  && Displays true (.T.)