TABLE OF CONTENTS The between and overlaps predicates both offer a shorthand way of showing that one value lies within a range defined by two other values. The BETWEEN predicate works with scalar range limits; the OVERLAPS predicate looks at two time periods (defined either by start and end points or by a starting time and an INTERVAL) to see if they overlap in time.
The predicate
((<= ) AND ( <= ))<a name="504"></a><a name="beginpage.BDC2BA02-527A-4DB7-BB08-B3C7624DF4F7"></a>
Please note that the end points are included in this definition. This predicate works with any data types that can be compared. Most programmers miss this fact and use it only for numeric values, but it can be used for character strings and temporal data as well. The
The results of this predicate with NULL values for
