You can't, unfortunately. You have two choices:
A) drop the table and re-create it with the new lengths.
B) Rename the old field, save it, and add a new field with the
old name and the new attributes. You don't want to do this on
a table with a lot of entries, since it can really waste space.
With B, I use this query to copy the data:
Update TableName Set Field=OldField
-- Dale E. Reed Jr. (email@example.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.emerald.iea.com-Emerald Mailing list (firstname.lastname@example.org)