This discussion reaffirms my conscious choice not to use BETWEEN in anything other than throwaway queries. It's a bit of syntactical sugar of dubious value - really, how much harder is it to write or read "x >= y AND x <= z"? - that admits a greater possibility of misunderstanding and unintended effects.