Sometimes you'll find that you need to order the results of a select statement in a way that is not alphabetical or reverse alphabetical. Here's how you do it in a single SQL SELECT Statement.
SELECT *, CASE WHEN Priority = 'High' THEN 1 WHEN Priority='Normal' THEN 2 WHEN Priority='Low' THEN 3 END orderSequence FROM TableName ORDER BY orderSequence DESC
This will return results where priority is Low comes before Normal which in turn comes before High.