Alastair: I tried your command and got the same results. I tried specifying #2 instead of just 2 and the command gave me results but they were not ordered correctly.
I then created a temporary view with a column name for the actual column and one for the length column and then selected the data and it worked correctly. Puzzling isn't it? It's not an answer to your problem but at least you have company and a workaround. Thanks -- Mike Ramsour -----Original Message----- From: Alastair Burr [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 20, 2002 12:59 PM To: R:Base ListServer Subject: Sort by function question Hi all, Has anybody got any idea why this gives a "Press OK to continue" message (and no data): select Full_Name, (slen(Full_Name)) from All_Names order by 2 whereas this works: select Full_Name, (slen(Full_Name)) from All_Names order by 2,1 I am sure, but willing to be proved wrong <g>, that I didn't have to sort both columns in v6.0a/Dos Thanks in advance, Regards, Alastair. ---------------------------------- A D B Burr, St. Albans, UK. ---------------------------------- [EMAIL PROTECTED] ---------------------------------- ================================================ 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/
