>I have a Create table statement which creates a table of about 200 fields. I keep getting a syntax error and I'm guessing it is because the line is so long. How do I use create table when I have a long list of fields?
In addition to the ALTER table approach, you could also create an array and use CREATE CURSOR FROM... then COPY STRUCTURE TO...
George
Ubi caritas et amor, deus ibi est