Here in this article I am going to explain how to use CASE statement in Order by clause to sort records with different columns of different data types based on condition.
Read this post on webcodeexpert.com