ALTER TABLE

[efrazier]

HI,

sorry this is a little pathtic, but I can't seem to get ALTER TABLE to work.
Could someone please send me an example of something simple like how to
change a column from a CHAR(255) to a VARCHAR(20). I don' care so much about
renaming columns and so on just changing their types. Hopefully without
distroying anything :)  

Thanks,

Eric