>Naomi
>
>Sorry for missing information
>
>It's just from a table to another
In this case, you would not be able to append character field into numeric, as far as I know. You can try instead
insert into myTable (field1, NumericField, Field3) select field1, cast(CharField as N(10,2)), Field3 from myOtherTable
If it's not broken, fix it until it is.
My Blog