Bojidar,

I agree, there are always degrees of safety, and they each have their own cost!
At least Michael has a choice of how to proceed.

Andy

Bojidar Alexandrov wrote:

> Andy Browne wrote:
> > Hi Michael
> >
> > 1) Add a temp field varchar(100)
> > 2) copy data from field to temp field (check the copy)
> > 3) drop field Varchar(40)
> > 4) add field Varchar(100)
> > 5) copy from temp field to new field (check copy)
> > 6) drop temp field.
> >
> > If you have dependancies you will have to sort those out first.
> >
> > This is long winded but safe!
> >
> > Andy
>
> Make three backups of database, restore them, compare databases to be sure
> Then save them on disks. One of them put in metal case at the office, other
> bury in the garden, and the third send at secure friend on the other side of
> the earth (in case of nuclear war)
> Then do: ALTER TABLE tablename ALTER columnname TYPE VarChar(100)
> And be happy :)
>
> --
> Bojidar Alexanrov
> Kodar Ltd.
> http://www.Kodar.net
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/