Use the BETWEEN and IN operators in a WHERE clause to retrieve multiple values.
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'
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'