> I'm currently using 1.03, the alter table statement cannot
> change the data
> type as requested. Create a new field to copy is somewhat
> difficult if the
> old field existed at procedure, trigger or other dependencies.
>

If you used IBExpert, it would build a script for you to completely revamp
that field as you like. Other tools may be equally capable. It's very quick
and easy and rebuilds dependent objects in their correct order.
Alan