>Hi all!
>
>was wondering if anyone can tell me what might have happened to truncate some field names in one of my tables. I believe these names were >10 chars and worked fine for awhile, but somehow they got truncated back to 10 chars, which of course messed up a few reports, etc. I do remember 'modifying' the table once or twice, but would this cause it? Or maybe it was deleteing and then re-adding the table....
>
>TIA,
>Dan

---

I got same problem as in table designer, it allow 11 character but when I:

Select * from table1 group by key1 into table2

the longer fieldname is truncated!!

what should be done is to change all fields, program... to fit in 10 character!

Anyway, truncate fieldname is not important, lose a column data is important!

Then, you're better to:

use table1 excl
Alter table1 rename column longfield1 to shortfld1
use in table1