I have a SELECT that will order by the field FA_TYPE, this field contains 2 characters and will have a description on a lookup table.

I want to order the FA_TYPE, but I don't want it ordered alphabetically - for example, I want it in the following order:

MO
FA
BR
HB
SB
SI
SS
HS
OH
OA
AP

How can I achieve this? would it be better to do a UNION using various Select statements?

Thanks in advance.
Kev