Using CASE in Order by Clause in SQL Server

If you need to use a CASE in the ORDER BY and you have 2 different types for the expression, you end up receiving this error: "Syntax error converting the nvarchar value 'Alice Mutton' to a column of data type int."
Check out the solution at Using CASE in Order by Clause in SQL Server - ExtremeExperts.