None of the options gave the expected order, so it was obviously a question about the Latin1_General collation rather than case sensitivity.

Luckily I guessed right 🙂