<< Should the results of a SELECT LISTOF be sorted if the SELECT command has an ORDER BY clause? >>
No. Think of what's happening internally in R:Base when you issue that SELECT statement: R:Base is returning a result set with a single row containing the result of the LISTOF function. The ORDER BY clause does, in fact, order the result set but since that result set has only a single row in it, there's not real meaning to the ORDER BY. << If not, is there an easy to way to sort the resulting list, or would I have to write a sort routine myself? >> First, create a VIEW on the table that contains an ORDER BY clause. Then perform your LISTOF query against the view, rather than the original table. -- Larry
