It's a shame that "Between -1 And -10" and "Between -10 and -1" aren't equivalent in T-SQL.

I haven't read BOL re. "Between" but does it state that it has to be Lower to Higher ?

If it was an Exam Question then I would've accepted both Answers.

David