is there a better way

[nichemtktg]

I have a column called priority that's an INT.

When I INSERT, the value in priority defaults to 0.

When I ORDER the column the zeros go to the top of the list.

I want them at the bottom of the list so I simply recode all zeros to 99. That solves my problem, but I'd like to know if there's a better way?

[cpradio]

I'm assuming you still want 1, 2 and 3 towards the top of the list so ORDER BY priority DESC would be out of the question. Couldn't you just change the default to 99 instead of 0?

[nichemtktg]

For everything there is a first time. Never thought of it that way, DUH! More proof that I see what I expect to see.

Thanks cpradio.