>Don't know if this will work all the time. Assume you have two fields with the same name "aaaaabbbbbccccc" in table "dummy". You can use the "alter table" command to change the name of one of the field:
>
>ALTER TABLE dummy RENAME COLUM aaaaabbbbbccccc TO newname
>
>You can always hope that the "alter table" command will consistently change the name of the first of the two dup fields, it seems to work that way. But one can never tell, it may find and change the name of the second field on the 101th try.
Thanks. I'll try that.