Re: increasing a field length in SQL

Dale E. Reed Jr. ( (no email) )
Fri, 21 Feb 1997 12:07:52 -0800

Josh Hillman wrote:
> I need to increase a field length from 25 characters to about 30 or 35 in
> SQL 6.5. What's the script to do that?
> The table is RadValues
> The field name is "Name"

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.  (       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  | Mailing list (