Michel,

ALTER TABLE mytable ;
  ADD COLUMN MyField1 C(10) ;
  ADD COLUMN MyField2 C(10) ...

The key is that there's no comma or anything else between ADD COLUMNs.

>Is there a way with ALTER TABLE to add more than one field without having to
redo the ALTER TABLE command?