>>Hi All,
>>
>>I'm writing a query witn an output to a table that already exists. Strange thing is that the order of the fields is not equal to the order as it is written in the query. It place the fields in alphabetic order in stead of how it is written.
>>
>>For example:
>>

>>Select  aveld, cveld, bveld from klm into table outputklm
>>

>>
>>I get the following order in the output table aveld, bveld, cveld. How could I solve this?
>>
>>Thanks beforehand
>
>You shouldn't rely in the order of fields in your code.
>
>However if you really need it, are you sure you're looking at the correct table?
>
>PS: You're saying to a table that already exists but creating a new one with select.
>Cetin

I have never seen that you can't rely on the order of fields in the code, neither in fox nor in SQL Server. AFAIK it's completely reliable. Am I mistaken?

Lennert