How to change the datatype of a field, when there is data.

shilpareddy

Dear All,

How can I change the data type of a field, when there is data in it?
for example, An integer filed in a table contains data, Now I would like to
change the data type of it to Decimal with out affecting data in it?
how can I achieve this?

kine

Create new field, move all data into this field, change datatype, move all data back (with needed conversions) and delete the temporary field... there is no one step solution...