assign another field to the importance table, maybe called priorityID
priorityID        Priority
0                   Low
1                   Normal
2                   High

Then order by priorityID desc



On Mon, 11 Oct 2004 12:30:37 -0400, Phillip Perry
<[EMAIL PROTECTED]> wrote:
> 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]

Reply via email to