Hugo Kornelis (11/17/2010)Without the reversal, the question would have been a solid test of whether people know about the dangers of using CASE in ORDER BY, and thus an excellent question. With the reversal, it's still a good question - good, not excellent.
The QoTD was not about dangers of using CASE in ORDER BY, but the problem is in the convertion in the CASE clause.