Thanks for the replies, works fine, I checked out the alter table syntax and added a new field. How can you add two new fields I tried with
ALTER TABLE DTD_Test add template_header varchar(255), template_footer varchar(255); but i get an error. Cheers