** method 1, e.g. lcCreate = "CREATE CURSOR cuMyCursor (cfixed1 c(10), nfixed2 n(5,2)" FOR ji = 1 TO 3 ** this loop will need more dynamic determination of data type lcField = "cnew" + ALLTRIM(STR(ji)) lcType = "c(10)" lcCreate = lcCreate + ", " + lcField + " " + lcType ENDFOR lcCreate = lcCreate + ")" &lcCreate ** method 2, create cursor and add to it CREATE CURSOR cuMyCursor (cfixed1 c(10), nfixed2 n(5,2)) FOR ji = 1 TO 3 lcField = "cnew" + ALLTRIM(STR(ji)) lcType = "c(10)" ALTER TABLE cuMyCursor ADD COLUMN &lcField &lcType ENDFOR