Hi

I'm creating a delimited file with

COPY TO (lfname) DELIMITED WITH CHARACTER |

but the output is putting quotes round text values as well as the delimiter.

If I only want the delimiter is there a copy to syntax I can use or do I have to handle it differently.

Thanks

Nick