transact-sql, Оператор BETWEEN

Документация:
https://docs.microsoft.com/en-us/sql/t-sql/language-elements/between-transact-sql

Возвращает: TRUE / FALSE

Формат: test_expression [ NOT ] BETWEEN begin_expression AND end_expression

Примечание: begin_expression >= test_expression <= end_expression

Примеры:

[Age] BETWEEN 18 AND 30

[Date] BETWEEN '20161212' AND '20170105'