Not ASCending nor DESCending ORDER BY

I have a statement

select a, code
from table_a, table_b
where some_conditions
ORDER BY a, ??

code could any letter
I want to order by a, ascending, and then by code in an arbitrary way (eg, in this order C, W, I, L, A, X, N... etc) how can I do that?

thanks

ps. please copy me when responding to group. Received on Tue Aug 18 1998 - 15:46:48 CDT