First Guide to SQL Anywhere Studio
   PART 3. Basic SQL
     CHAPTER 12. Selecting Data from Database Tables       

Short cuts for typing search conditions

Using the shortform BETWEEN 

SQL has two short forms for typing in search conditions. The first, BETWEEN, is used when you are looking for a range of values. For example the following query:

SELECT emp_lname, birth_date
FROM employee
WHERE birth_date BETWEEN '1963-1-1'
AND '1965-3-31'

is equivalent to the following:

SELECT emp_lname, birth_date
FROM employee
WHERE birth_date >= '1963-1-1'
AND birth_date <= '1965-3-31'

Using the short form IN 

The second short form, IN, may be used when looking for one of a number of values. The command

SELECT emp_lname, emp_id
FROM employee
WHERE emp_lname IN ('yeung','bucceri','charlton')

means the same as:

SELECT emp_lname, emp_id
FROM employee
WHERE emp_lname = 'yeung'
OR emp_lname = 'bucceri'
OR emp_lname = 'charlton'