>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

And what goes wrong? Btw, instead of ALLTRIM(str()), you can simply use Transform().

Update: Try Copy To (refa) DELIMITED WITH "" WITH CHARACTER "|".....