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?
its 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? Youre column should either be a numeric or string, both of which are obviously sortable.