Transact-SQL Keywords: BETWEEN

	SQL Keywords: BETWEEN

Description

The BETWEEN keyword is used to create a type of conjunction based on two fields. The BETWEEN keyword is combined with the AND keyword. The formula to follow is:

Expression BETWEEN Start AND End

Expression is the name of the column whose values you want to examine.

Start is the starting value of the range to consider.

End is the highest value to consider in the range.

After this condition is executed, it produces the list of values between Start and End. Here is an example:

USE VideoCollection1;
GO

SELECT Title, Director, YearReleased, Rating
FROM Videos
WHERE YearReleased  BETWEEN 1998 AND 2006;
GO