The "between" operator
The between operator allows you to check if a value is in a range of
values. It can be used with the operator not to check if a value is not in
the range of values specified. The expression is structured as
follows:
The comparison is inclusive of the start and end values.
value between start_value and end_valueFor example, the following expressions return
true:
500 between 500 and 600
rating = 500, rating not between 501 and 600Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!