Comparisons

You can use comparisons in logical expressions.

Syntax:

Comparisons use the general syntax of compOp (comparison operator) expression.

The compOp can be one of: <, <=, ==,=,<>,!=, >=, or >.

=,==  are the same

!=,<>  are the same

Examples:

@{fName} == "James"

SELECT age FROM customers WHERE id = ?; > @{ageThreshold}

@{SALARY} <= 20000

@{birthDate} > #01/01/2000#

The comparisons have lower precedence than the arithmetic so writing 5 + 3 > 2 + 9 is equivalent to writing (5+3) > (2+9)

To make sure that both sides of the comparison expression belong the same data type (string, number or date), it is recommended to apply AsString, AsNumber or AsDate functions to each side of the expression.