Bad Habits & Best Practices / SQL Server October 19th, 2011 What do BETWEEN and the devil have in common? Learn why you shouldn't use BETWEEN for date range queries, even with the date data type.