Suppose that value1 and value2 are dates, and that date is a date field in the database. This query:

Code:
SELECT *
FROM table
WHERE date BETWEEN value1 and value2
returns all the rows where the date field is between value1 and value2.

What if I want to return all the rows where the date field goes just from value1 or just to value2? Is this possible using BETWEEN?