Using shortcuts for search conditions

Using the short form BETWEEN

SQL has two short forms for typing in search conditions. Use the first, BETWEEN, when you are looking for a range of 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 the short form IN

Use the second short form, IN, to look for one of a number of values. The command. 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'