Ordering by a complex field

I have a one varchar field.

I'd like to order so that records where field='2' come first, then '1', then '9', then anything but '0', then '0'.  Is there anyway to do this in a standard order by clause (that is, without writing a new SQL function)?