ID : 631

<,=,> (Comparative) Operators

Function

To compare a left-hand expression and a right-hand expression.

Syntax

expression1 comparisonoperator expression2

Guaranteed entry

expression1: Designate any expression.
comparisonoperator: Designate any comparative operator.
expression2: Designate any expression.

Return value

Return True/False.

Description

Left-side and right-side values of the operator are compared.

If types of the left-hand and right-hand data are different, they are automatically converted into the one with higher priority and compared. A cast error occurs if automatic conversion into the same type is not allowed. Refer to "Data type priority in dyadic operation."

For comparison of position data, only "=" and "<>" can be compared. Moreover, comparison cannot be performed unless the data type is the same.

Types of comparative operators (`comparisonoperator`)

Operator	Meaning	Data type
<	Smaller than	Numeric data and string type data
<=	Equal to or smaller than	Numeric data and string type data
>	Larger than	Numeric data and string type data
>=	Equal to or higher than	Numeric data and string type data
=	Equal to	Numeric data, string type data and position data
<>	Not equal to	Numeric data, string type data and position data

Related Terms

Data Type Priority in Dyadic Operation

Attention

Example