I just tried it in RBDos and RBWin, latest build each, and it worked just fine for me. I also did ORDER BY 2 DESC and that worked too.
Bill Cook Kent WA USA ----- Original Message ----- From: "Bill Downall" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 20, 2002 12:47 PM Subject: Re: Sort by function question > That's not so weird, actually. When you use the # symbol with a > number, your order by clause has a different meaning than when you > use an ordinal number without the # symbol: > > ORDER BY 2 > > means put in order by the second item selected, in the list of columns > and expressions after the word SELECT and before the word FROM in > this query. > > ORDER BY #2 > > means put in order by the second physical column in the table or view > after the word FROM, regardless of whether it is presented in the > SELECT list. > > You are still sorting your list, but you may be sorting it by some value > not visible. > > > > On Wed, 20 Mar 2002 20:18:49 -0000, Alastair Burr wrote: > > >Hi Mike, I'm glad to know that I've got company!! > > > >I, too, tried the # symbol in the command and got data but not sorted. > >It is weird, isn't it? Sorting both columns is not a problem - might even > be > >a good thing - but I'm sure it's different from how it used to be. > > > > > > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
