Relational Operators

Relational operators return a Boolean value of True or False.

Operator	Meaning
=(oreq)	equality or assignment
<>(orne)	inequality
>(orgt)	greater than
<(orlt)	less than
>=(orge)	greater than or equal to
<=(orle)	less than or equal to
between...and...	is greater than or equal to one expression and less than or equal to the other
not between...and...	the opposite ofbetween
like(or?)	string string equals, with wildcards * (matches zero or more characters) and ? (matches one character for each ?)
not like	the opposite oflike
contains	contains the character sequence (for strings); contains an element matching the value (for arrays)
matches	matches a regular expression; for more information, seeRegular Expressions

The relative comparison operators, >, <, >=, and <= only work on integer, real, and string expressions. The equality operators, = and <>, work on some other expression types as well, such as colors. The like, not like, and matches operators work only on string expressions. The contains operator works on string and array expressions.

Here are some sample expressions that use relational operators:

"He" + "llo" = "Hello" //True

1 + 2 <> 3 //False

"ABC" < "ABD" //True

5 not between 1 and 10 //False

"GIS" like "GI?" //True

{1, 2, 3} contains 2 //True