This got lost in the mists of time in the sonetmail hiccup: Does anybody agree with me that this fails:
SELECT (LISTOF(Extension)) INTO vResponse FROM FileExtensions order by Extension but these work: SELECT (LISTOF(Extension)) INTO vResponse FROM FileExtensions SELECT (LISTOF(Extension)) INTO vResponse FROM FileExtensions where Extension is not null SELECT (LISTOF(Extension)) INTO vResponse FROM FileExtensions where Extension is not null order by Extension (They're all single-line commands.) If so, should I expect the first method to work or not? Since then it has been discovered that the third "working" example doesn't appear to actually sort but doesn't give the error message that the non-working example does. A easy work-around of using a (temp) view to re-order the list has also been suggested and the need, or otherwise, of two pairs of parenthesis has been questioned. (R:Syntax shows both!) See what excitement you've missed while you were away! Welcome back. Regards, Alastair. ---------------------------------- A D B Burr, St. Albans, UK. ---------------------------------- [EMAIL PROTECTED] ----------------------------------
