SQL BETWEEN Operator

Sql Between operator find the database in between two database values. this operator used between and not between data filtering database.

SELECT * FROM tablename WHERE cost BETWEEN 200 AND 300

Sample code

SELECT * FROM tablename WHERE cost BETWEEN 200 AND 300 
 SELECT * FROM tablename WHERE Date BETWEEN #02/02/2014# AND #07/07/2014#