hello all,

what is the correct SQL syntax to set the physical position of a field into
a table?

I have to change the size of a field so I'm doing:

1. Creation of a TEMP field
2. Copy values of field to change into TEMP
3. Drop field to change
4. Creation of the field with new size
5. Copy of values from TEMP into new field
6. Drop field TEMP

At point 4 I'd like to set the position of the new field the same as before.
Is it possible?

ALTER TABLE PROVINCES ADD LONG_NAME CH_PROVINCE_LONG_NAME POSITION 3;

This syntax doesn't work, at least into IBExpert.

Thanks
Salvatore