How to shorten a column's length that already HAS data in it?

Hi!

    I have some columns that have a lot of padding after the last letter of the entries. I tried to alter
them using the "alter table" command, but it tells me they have to be empty in order for this to work.
I tried to copy the column to a view, shorten the original column length, but when I try to put them back, of
course I'd get the error that the data is "too long" for the column because of the padding....any suggestions
other than manually re-entering the data?

Thx so much in advance!

--

Check out my site! (Still under construction!) http://members.home.net/rballard34/
Sign the guestbook if you like!

-Rah
Received on Sun Oct 14 2001 - 18:41:44 CDT