I have a database with a number of fields (things like postal address)
that were originally (mistakenly) created as TEXT and that only need to
store a few characters. Is it possible to use ALTER TABLE to convert
them to VARCHAR? If I have to I can always add a new column, copy the
data too it, delete the old column and then rename the new, but I am
hoping that there is an easier way.