>I sure wish the ALTER TABLE ADD COLUMN command allowed you to specify where you wanted the new field to go!
>
>Instead of using an AFIELDS and then inserting a new row into the array and creating a new table to APPEND into, REMOVEing the old table from the DBC, deleting the old table, renaming the new table to the old table and then adding it to the DBC, is there an easier way or am I just too tired to think of a better way on a Friday afternoon?
>

This may be a dumb question, but why is the physical order of the table's columns an issue? You can always create a view with the columns ordered as needed, and if it's a matter of some data import issue, you can construct a table in the proper order for the import, load the records into that, and then append from the intermediate table. If the changes are made through MODIFY STRUCTURE, you can resequence there by hand.