hi all-

I need some help with this code..
nbook, x and are numeric that keep chaging by various increments. What I want to to is create file names for outputing to a text file that change as the numbers change.

example
outfile = file-1-3.txt
outfile = file-12-1.txt
outfile = file-5-9.txt

outfile = "file-"+(STR(nbook))+"-"+(STR(x))
SELECT * FROM infile WHERE (chapter%2) =1 INTO FILE outfile.txt

thanks