BETWEEN ... AND ...
returns true for all cases of a column that are in the closed interval given. Returns false otherwise. The reverse is true for NOT BETWEEN ... AND ...
.
table.column BETWEEN inclusive start of interval AND inclusive end of interval
table.column NOT BETWEEN inclusive start of interval AND inclusive end of interval
Supported value types for the interval start and end points are STRING, INT, FLOAT and DATE. The interval start and end points must be of the same type.
[NOT] BETWEEN ... AND ...
can be used in the following contexts:
Note that if the left value is larger than the right value, BETWEEN
evaluates to false.
If one of the input values (the input column or the interval start/end) is NULL, then the output will be NULL as well.
Comparison of strings is case-sensitive.