>I am trying to build a table using the following syntax..
>
>AA="("
>FOR I = 1 TO 200
>if i = 200
>AA=AA+'TEMP'+ALLT(STR(I))+' c(25)'
>else
>AA=AA+'TEMP'+ALLT(STR(I))+' c(25)'+' ;'+CHR(13)
>endif
>NEXT
>aa=aa+')'
> CREATE TABLE test &AA
>
>
>Any idea why it doesn't work ?
>Thanks

Adam, try this:

aa = "CREATE TABLE test ("
FOR I = 1 TO 200
IF i = 200
AA=AA+'TEMP'+ALLT(STR(I))+' c(25))'
ELSE
AA=AA+'TEMP'+ALLT(STR(I))+' c(25)'+','
ENDIF
NEXT
&aa