>I intend to create a new table where a numeric field will be an
>integer field instead.
>
>Then I will append all data from the old table, and the numeric
>field will be appended to the integer field.
>
>1- Is there any problem on appending directly ?
>I have no decimals in the older field.
No, no problem.
>
>2- What is the real size of an integer field ?
>In build table time it looks like 4, which seems too small
It is 4 :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
