Between: which operator checks for values within a range?

Between: which operator checks for values within a range?

• A. BETWEEN
• B. NOT
• C. IN
• D. CAST

Answer: (A)

Checking whether a value lies inside a defined numeric or temporal range is what the BETWEEN operator is designed for. It evaluates to true when the value is between the lower and upper bounds, including both endpoints. This makes it ideal for filtering data within a continuous span, such as ages or dates. For example, selecting records with a date between two dates will include those endpoints. The other operators serve different purposes: NOT is a negation used to invert conditions; IN checks whether a value matches any value in a specified list (not a continuous range); CAST changes the data type of a value and does not perform range checks. You can also use NOT BETWEEN to exclude a range, but BETWEEN is the straightforward way to include values within a range.

Checking whether a value lies inside a defined numeric or temporal range is what the BETWEEN operator is designed for. It evaluates to true when the value is between the lower and upper bounds, including both endpoints. This makes it ideal for filtering data within a continuous span, such as ages or dates. For example, selecting records with a date between two dates will include those endpoints. The other operators serve different purposes: NOT is a negation used to invert conditions; IN checks whether a value matches any value in a specified list (not a continuous range); CAST changes the data type of a value and does not perform range checks. You can also use NOT BETWEEN to exclude a range, but BETWEEN is the straightforward way to include values within a range.