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!