>Hi,
>I made a select sql and the fields I listed in the command are not shown in that order.
>How can I force them into the order as they are listed in the query.

The fields are in the order you specified in the query. How do you view the result? If you use BROWSE command, run it w/o LAST option.