While I would usually use Between StartDate And EndDate properly, today I found one mistake where I'd used it back to front and needed to test if it would work:
Select 1
Where Cast('1 Jan 2011' As Date) Between Cast('20110102' As Date) And Cast('20110101' As Date)
Nope!