Re: Remove space character from query output

Mark D Powell wrote:
>
> 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 --

Hm, what's wrong with:
set colsep , ???

-- 
Gtrz,

Frank van Bortel