Hi Agnes,

uses "external domain tokens" algoritm:

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