Re: order by question

Hi Andrius, try "order by date desc" Steve At 9:12 PM -0700 11/9/01, Andrius Jakutis wrote:

Ok, here is the question: I write to order by date "Order by date". So, it output's something like this: 2001 08 01 2001 08 02 2001 08 03 What if I want to order by date, but not from the older to newest, but from newest to older ? The same is with numbers - priority I use order by priority. It lists: 1 2 3 4 But how to list like this: 4 3 2 1 Thanks -- --------------------------------------------------- "Minds are like parachutes, they work best when open" Support free speech; visit http://www.efa.org.au/ Heads Together Systems Pty Ltd http://www.hts.com.au Email: hts@hts.com.au Tel: 612 9982 6767 Fax: 612 9981 3081