This comparison is testing a column for being falling in side or outside (used with NOT) a range of values.
col1 [NOT] BETWEEN valueA AND valueB
In this example valueA and valueB could be another column or a constant of the same type as the column being compared against. It is equivalent to coding two simple conditions as follows:
[NOT] (col1 >= valueA AND col1 <= valueB)