Complex ORDER BY clauses

Hi all,

Suppose that I have a column in a table, and I want to sort it so that certain values come first, but the sorting is not lexographical. For example, if I have a rediculously simple table, that has only one column, like so:

'A'
'B'
'C'
'D'
'E'

I want to sort the table so that Bs and Es come first, like so:

'B'
'E'
'A'
'C'
'D'

Is there some way to do such a thing?

Dave Received on Thu Nov 13 2003 - 11:51:26 CST