Martin Dew wrote:

>
> alter table patient_triage_cons
> alter ACTION_TYPE TYPE VARCHAR(10),
> alter ACTION_NOTES TYPE VARCHAR(8192)
>
>
> Could any other guru's confirm that by using the above statement my
> field sizes in the database will increase to the amounts specified,
> without affecting the underlying data (both fields are currently smaller
> in size than their new specification).

The statements will not increase the field lengths _by_ the
amount specified, but will increase them _to_ the length
specified. Increasing _by_ the amount would add 10 characters
to the first field and add 8192 characters to the second.
Increasing _to_ the amount makes the first field 10 characters
long and the second 8192 characters long.

That quibble aside, the statement will work as long as the
first field was 10 characters or less and the second 8192
or less. You can't use alter field to shorten a field.

Regards,


Ann