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/
