BETWEEN

An operator that tests whether a value lies in a range, including both ends.

In more detail

BETWEEN 1003 AND 1005 includes 1003 and 1005. On dates stored with a time part, an inclusive upper end can quietly leave out most of the last day, so many people prefer >= start AND < next day.

Related terms

Taught in

References