[GENERAL] Ordering by a complex field

[Robert James]

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)?