sqlcmd="SELECT aField, bField AS Field2, [, ]+PADR(cField,2) AS cField ..." ? STRTRAN(STRTRAN(strtran(m.sqlcmd,"[, ]",CHR(1)),", ",","+CHR(13)+" "),CHR(1),"[, ]")but i think you want this:
? STRTRAN(STRTRAN(strtran(m.sqlcmd,"[, ]",CHR(1)),", ",","+CHR(10)+" "),CHR(1),"[, ]")Fabio
