table output order

I have the latest version of SE (7.?) running on an HP-UX version 10.2. I set up a table of 3 fields one of which is a sequencial number from 1-700. The sequential column is indexed. The data is loaded into the table in ascending order, i.e. 1 2 3 . . . When I do a 'select * from tablename' in SQL or do an escape in the sequential field in a PERFORM screen the rows are displayed in reverse order by sequential number, i.e. 700 699 698 . . . I would like them to list in ascending order, i.e. 1 2 3 . . . Is there any way to do this?

ORDER BY ? "Richard E. Hassler" wrote: > I have the latest version of SE (7.?) running on an HP-UX version 10.2. > > I set up a table of 3 fields one of which is a sequencial number from > 1-700. The sequential column is indexed. The data is loaded into the > table in ascending order, i.e. 1 2 3 . . . > > When I do a 'select * from tablename' in SQL or do an escape in the > sequential field in a PERFORM screen the rows are displayed in reverse > order by sequential number, i.e. 700 699 698 . . . I would like them to > list in ascending order, i.e. 1 2 3 . . . Is there any way to do this?