change a column

Hi,

I'm sorry if this question has been asked a million times already but
is there really no other way to change the type of a column other than
creating a new table in selecting the original one into it?

Cheers,
Christian

--
("`-''-/").___..--''"`-._ (\
Christian von Kietzell `6_ 6 ) `-. ( ).`-.__.`)
mailto: chris@gammu.ath.cx (_Y_.)' ._ ) `._ `. ``-..-'
Jabber: cuboci@charente.de _..`--'_..-_/ /--'_.' ,'
(il),-'' (li),' ((!.-'