select
case when importance = 'high' then 1
when importance = 'normal' then 2
when importance = 'low' then 3
end
as importance_order
from importance_table
order by importance_order
-----Original Message-----
From: Phillip Perry [mailto:[EMAIL PROTECTED]
Sent: Monday, October 11, 2004 12:31 PM
To: CF-Talk
Subject: grouping by...
Hi,
I want to arrange my data that is being displayed by the database field
"importance". I want High to be shown first, then Normal, then Low (which
are the 3 choices in the importance table"). How can i get Normal items to
show up before Low items?
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
