Number comparison functions
Number comparison functions define conditions based on numbers.
In addition to natural language, you can use mathematical symbols to compare numbers. For
example, you can use the amount of the shopping cart ≥ 1000 and the amount
of the shopping cart is at least 1000 interchangeably.
The following table lists the natural language syntaxes and mathematical symbols available to compare numerical excodephssions:
| Syntax | Mathematical notation | Unicode | Description | Example |
|---|---|---|---|---|
<number> does not equal <number>
|
x ≠ y | U+2260 | Tests that a number is not equal to another number. |
if the number of rentals does not equal 3
|
<number> equals <number>
|
x = y | U+2A75 | Tests that a number is equal to another number. This is equivalent to the is <number> operator |
if the number of rentals equals 3
|
<number> is <number>
|
n/a | n/a | Tests that a number is equal to another number. This is equivalent to the equals <number> operator |
if the number of rentals is 3
|
<number> is at least <number>
|
x ≥ y | U+2265 | Tests that a number is greater than or equal to another number. |
if the number of rentals is at least 3
|
<number> is at least <number> and less than <number>
|
n/a | n/a | Tests that a number is included in a range in which the first value is included and the last value is excluded. |
if the age of customer is at least 12 and less than 25
|
<number> is at most <number>
|
x ≤ y | U+2264 | Tests that a number is less than or equal to another number. |
if the number of rentals is at most 3
|
<number> is between <number> and <number>
|
n/a | n/a | Tests that a number is included in a range in which both values are included. |
if the age of customer is between 12 and 25
|
<number> is less than <number>
|
x < y | U+FF1C | Tests that one number is less than another. |
if the number of rentals is less than 3
|
<number> is more than <number>
|
x > y | U+FF1E | Tests that one number is greater than another. |
if the number of rentals is more than 3
|
<number> is more than <number> and at most <number>
|
n/a | n/a | Tests that a number is included in a range in which the first value is excluded and the last value is included. |
if the age of customer is more than 12 and at most 25
|
<number> is strictly between <number> and <number>
|
n/a | n/a | Tests that a number is included in a range in which the first value is excluded and the last value is excluded. |
if the age of customer is strictly between 12 and 25
|