Adjust SQL Query to force a record to appear first?

Question

How can the below query be adjusted to return always the member with MemberID = 'xxx' as the first row

SELECT * FROM Members

Answer 1

select * from Members
order by case when MemberID = XXX then 0 else 1 end

Answer 2

This should work and it will also allow you to order the remaining items by MemberID (Assuming xxx=12 in this example)

SELECT *
FROM Members
ORDER BY CASE WHEN MemberID=12 THEN NULL ELSE isnull(MemberID,0) END

If the memberID column can't contain nulls, you can get away with this which might perform slightly better.

SELECT *
FROM Members
ORDER BY CASE WHEN MemberID=12 THEN NULL ELSE MemberID END