>Hi all,
>I find a strange behavior using 'DESC' and 'order by'. i.e. 'select lastname,firstname from myfile into cursor mycursor order by lastname,firstname desc' do not work. without 'desc' or without 'firstname' (with only one order by) it works.
>Some suggest?
>Thanx

Francesco,

You need to use the DESC keyword for each field that you want that order on. So,

SELECT LastName, FirstName ;
  FROM MyFile ;
  INTO CURSOR MyCursor ;
 ORDER BY LastName DESC, FirstName DESC

should do the trick.

Regards