Re: Changing datatypes of existing field?

Quoting Jim Kistler... > > I need to change the datatype of an EXISTING field from "char" to > "text" (moving from SE to OnLine) and apparently have to copy all the > db's existing field entries out, remove the "char" field, replace it > with the "text" field and then copy all the field entries back.......? > > Has anyone faced this situation?.......and can offer advice? > Yup, and it's easy. Make a schema (w/dbschema) of the offensive table, unload the table, drop the table, alter the schema accordingly, build the table, load it up. DAS -- Dave Snyder @ Bell Atlantic - Philadelphia, PA WORK: ddx85qr@boots.bell-atl.com HOME: dave@das13.snide.com