[mcubitt]

When I make a change to my SQL statement in MS Query (via Excel), if the change involves a column it seems to move that changed column to the end of the columns, putting it out of position.

EG

if I had

select rpad(sid,10), rpad(machine,20), rpad(status,10) from v$session
MS Query would return
SID and MACHINE and STATUS
and back in Excel would be
SID in column A and MACHINE in column B and STATUS in column C.

If I changed it to
select rpad(sid,10), rpad(substr(machine,1,length(machine)-1),20), rpad(status,10) from v$session
MS Query would return
SID and MACHINE and STATUS
BUT back in Excel would be
SID in column A and STATUS in column B and MACHINE in column C.

Is it possible to stop this? It is really annoying and surely a bug!