T-SQL » Operators » BETWEEN ... AND ...

Syntax:
SELECT { * | fieldlist } FROM table
WHERE expression [ NOT ] BETWEEN start_value AND end_value
fieldlist
The list of fields that are to be retrieved from the table.
table
The name of the table from which the information is being retrieved.
expression
The field on which to test for the range specified by the start_value and end_value.
start_value
The parameter that indicates the starting position of the range being searched.
end_value
The parameter that indicates the ending position of the range being searched.

The BETWEEN ... AND operator is used to specify a selection criteria by requiring an expression to be equal to one of, or fall between the range defined by, two values.

These values can be numbers, characters, strings, or dates, but you cannot use any wildcard characters. The characters, strings, and dates must be enclosed by a pair of single quotes.

Examples

Code:
SELECT Title FROM ElvisSongs
WHERE ReleaseDate BETWEEN '1/1/56' AND '12/31/57';
Output:
Title
Heartbreak Hotel
Blue Suede Shoes
Jailhouse Rock
Teddy Bear

(4 row(s) affected)
Explanation:

In this query, we search for song titles released from 1956 until 1957.

Language(s): MS SQL Server
Code:
SELECT Title FROM ElvisSongs
WHERE ReleaseDate NOT BETWEEN '1/1/56' AND '12/31/57';
Output:
Title
Hard Headed Woman
My Wish Came True
A Big Hunk of Love
Stuck on You
Crying in the Chapel
Suspicious Minds

(6 row(s) affected)
Explanation:

This query uses the NOT operator to search for values that lie outside the range specified.

Language(s): MS SQL Server