I am performing a query and an ASCII export within a DTS job.
The conditions have been set for the export as Vertical line (PIPE) as the
delimator and having a hard return at the end of each row. How can I put a
vertical line at the end of each row. I tried forcing a new column with PIPE
but I ended up with two PIPES at the end.

Need the export to look like below:
Harry Smith|123 Main Street|Playstation3|
John Smith|421 Main Street|Playstation3|
Jane Smith|123 Main Street|Playstation3|


Current export without the pipe at the end:
Harry Smith|123 Main Street|Playstation3
John Smith|421 Main Street|Playstation3
Jane Smith|123 Main Street|Playstation3

TIA!

Hello Mike,


The format with the pipe at the end would suggest to something reading it
that there is another column after the pipe (always blank) wouldn't it?

If this is really what you want then I would be inclined to concatenate the
pipe onto the end of the last column like this

SELECT
c1,
c2,
c3 + '|' as c3
FROM
t1




Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com