The BETWEEN operator picks values from a specified range. Numbers, text, and dates can all be used as values. The BETWEEN operator includes both begin and end variables. WHERE BETWEEN returns values that fall within a specified range. BETWEEN is an abbreviation for >= AND =. BETWEEN is inclusive, which means that both the start and finish values are included.