Format Query

[howdie007]

I currently have a query thas produces data in the following format...
"12/31/2003","BF985","CDS","08/01/2003","12/31/9999","000.00","000200000.00","000000000.00"," "," Butler"," Franklin","D","R1","Others"


I would like the same to be in the following format.....

12/31/2003|BF985|CDS|08/01/2003|12/31/9999|000.00|000200000.00|000000000.00|Butler|Franklin|D|R1|Others


How can i achieve this ?

Thanks.

 

[SteveR77]

Is this the dump of the data from the query to a file or is it the way the actual fields are displayed?

 

[howdie007]

This is the way it writes to a file

Using concatenate in the sql i have reduced it to...

"12/31/2003|BF985|CDS|08/01/2003|12/31/9999|000.00|000200000.00|000000000.00|Butler|Franklin|D|R1|Others"

Is there a way to remove the first & last quote ?

Thanks.