• Well, put me down as someone who did not know you could use CASE in the ORDER BY clause, although now that I've seen it, it makes sense. I can definitely make use of this.

    Thanks for the good question.

    Although, now that I've thought about it a bit more, it seems to me that the CASE clause could be a performance hit?