I am creating a file name and then trying to create that file with data from a single record in a table a table - what am I doing wrong?

SELECT collections

refa="c:\driver\"+ALLTRIM(str(collections.refno))+ALLTRIM(collections.driver)+".csv"

Copy To refa DELIMITED WITH "" WITH CHARACTER "|";
FIELDS acclient,acad1,acad2,acad3,acad4,accontact,actel,coldate,readyat,closedat,notes,commodity,pieces,weight,globcutoff