>>Create the new table using the CREATE TABLE command, with the correct ordering of fields. Then APPEND FROM the original table.
>>
>Hmm, it seems to me that original table will still have old field order after that. :)
Oh, I left the rest as an excercise for the reader.
Just forgot to give the assignment. :)
Steve Gibson