Alastair Using RBWIN build 1.851 a similar command on a different database works fine:
SELECT DNameL, (SLEN(DNameL)) FROM Drivers ORDER BY 2 DNameL is a text data type. What datatype is your column? What build are you using? David BLocker ----- Original Message ----- From: "Alastair Burr" <[EMAIL PROTECTED]> To: "R:Base ListServer" <[EMAIL PROTECTED]> Sent: Wednesday, March 20, 2002 12:58 PM 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/
