Using Shortcuts for Search Conditions

Use the BETWEEN and IN operators in a WHERE clause to retrieve multiple values.

Using BETWEEN

The BETWEEN operator is used in a WHERE clause to select a range of data between two values. For example, the following two example queries are equal:

SELECT Surname, BirthDate
FROM Employees
WHERE BirthDate BETWEEN '1964-1-1'
AND '1965-3-31'

SELECT Surname, BirthDate
FROM Employees
WHERE BirthDate >= '1964-1-1'
AND BirthDate <= '1965-3-31'

Using IN

Use the IN operator to specify multiple values in a WHERE clause. The following two example queries are equal.

SELECT Surname, EmployeeID
FROM Employees
WHERE Surname IN ('Yeung','Bucceri','Charlton')

SELECT Surname, EmployeeID
FROM Employees
WHERE Surname = 'Yeung'
OR Surname = 'Bucceri'
OR Surname = 'Charlton'