StoutFiles - 2:01 pm on Feb 5, 2013 (gmt 0)

i never use BETWEEN i always use: WHERE x>=y AND x<=z

BETWEEN is translated to x>=y AND x<=z anyways, so it makes no difference speed wise. I agree that it's better to not use BETWEEn given you get a better level of control with no speed costs.