Re: Remove space character from query output

sjefke12_at_hotmail.com (Foggy) wrote in message news:<f78e018a.0112210402.5f5030c8_at_posting.google.com>...
> Hello,
>
> when I run a query, the output always contains an space character
> between the columns. Is it possible to remove this space? Our customer
> wants a comma delimited output, without spaces. Is there an other way
> to achieve this?
>
> Thanks in advance.
>
> Johan

The following is a link to the article which contains example SQL to generate just what you asked for:

How do I export a database table to a flat file? To a comma or other character delimited file ?
http://www.jlcomp.demon.co.uk/faq/flatfile.html

• Mark D Powell --