Operator to check for value occurrences in the range

BETWEEN operator is used to check if the right-side expression value is within the left-side range (including the range borders). If the value falls within the range, the operator returns TRUE, else — FALSE. You can inverse operator action by using NOT. Value Comparison Rules are used to compare the values.

Example:

SELECT
Catalog.Nomenclature.Description,
   Catalog.Nomenclature.ProcurementPrice
WHERE
   Catalog.Nomenclature.ProcurementPrice BETWEEN 100 AND 1000