>All,
>
>I am converting data to use in out new system. The old system has Numeric fields that I need to change to Interger types for the new structure. APPEND FROM informs me that I have a data type mismatch. Using the INT function to change the type does not work. What (if any) is the function to change numeric data to integer data so I can finish my processing.
>
>TIA
>
>Rex
>
>PS - I know I can write the data to a text file and APPEND SDF, but I should not have to do this.

Rex, if this is just one-time operation, what if you make it numeric field in the new table, append data, then change the structure to make it Integer?