SELECT Region, Contact
FROM Fig1
ORDER BY
CASE Region WHEN 'Durban' THEN 1 ELSE 2 END,
Contact
Tip, you can do:
SELECT TOP 100 PERCENT * FROM Fig1
Even better tip: Don't do that - your query doesn't guarantee (although will more than likely result in) the correct ordering. You should have sorted by outerSeq, Contact in the outer query. See http://blogs.msdn.com/b/queryoptteam/archive/2006/03/24/560396.aspx