You're syntax for using BETWEEN is not correct.

Here's an example:

USE pubs
GO
SELECT title_id, ytd_sales
FROM titles
WHERE ytd_sales BETWEEN 4095 AND 12000
GO

This syntax is in the BOL.