if Statement Comparators - UDM


The following table lists all of the comparators that can be used in an if statement to determine the type of comparison to be made between the left-hand and right-hand values.
 

Comparator

Description

EQ (Equal)

Evaluates to true if the left-hand and right-hand values are equal.
 
If one or more of the values contains alpha characters (non-numeric), the comparison is case insensitive.

NE (Not Equal)

Evaluates to true if the left-hand value is not equal to the right-hand value.
 
If one or more of the values contains alpha characters (non-numeric), the comparison is case insensitive.

LT (Less Than)

Evaluates to true if the left-hand value is less than the right-hand value.
 
LT performs a numeric comparison.

GT (Greater Than)

Evaluates to true if the left-hand value is greater than the right-hand value.
 
GT performs a numeric comparison.

LE (Less Than or Equal)

Evaluates to true if the left-hand value is less than or equal to the right-hand value.
 
LE performs a numeric comparison.

GE (Greater Than or Equal)

Evaluates to true if the left-hand value is greater than or equal to the right-hand value.
 
GE performs a numeric comparison.

 

For an explanation of how these comparators are used, see Comparison Operations.