[thelist] SQL ORDER BY

[Rickards, Julian (NDM)]

Even cooler!

-----Original Message-----


select *
from ...
where ...
order by case class
        when 'Open' then 1
        when 'Closed' then 2
        when 'Suspended' then 3
    end;