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