>How to change datatypes of een existing fields
SQL Server 6.5 did not allow you to change the datatype for an existing column. You had to drop and re-create the table. SQL Server 7.0 does have this functionality through the ALTER TABLE statement but there are some constraints to changing a column's datatype. One of the biggest is that SQL Server must be able to implicitly convert between the two datatypes.
-Mike