custom sorting of records in sql server

How to implement custom sorting using SQL ORDER BY CLAUSE ?

 5,931 total views,  3 views today