SQL: Sequence Your Result Set

Say you want to order your result set in a specific way besides just ascending or descending. Here is a simple way to do that.

SELECT your_field,
CASE WHEN your_field = 'c' THEN 0
WHEN your_field = 'a' THEN 1
WHEN your_field = 'b' THEN 2
ELSE 3
END AS order_sequence
FROM your_table
ORDER BY order_sequence

Downside is the query will return an extra field of data (order_sequence)