query to sort a column in a customized order

[alanchinese]

is there a way to write a query sorting a column in a customized order?

it's possible to create a table referencing all possible values in that column and assign sort order in the new table.

if no new table can be added, are there any easy ways?

thankx.

[Gill Bates]

What do you mean? You're column should either be a numeric or string, both of which are obviously sortable.