Re: How do I Insert newlines between columns

From: Kenny Gump <kgump_at_mylanlabs.com>
Date: Wed, 26 May 1999 13:43:54 -0400
Message-ID: <374c32cc.0@news.mountain.net>

select column_a, chr(10),

          column_b , chr(10),
          column_c , chr(10)

from table_name

Hope this helps. 'chr()' is a function that puts the character of the = ascii value you supply. 10 is linefeed.

Kenny Gump
Keith Jamieson wrote in message <374BD061.BB003165_at_email.mot.com>...

    I have an SQL statement as follows:     select column_a,

              column_b 
              column_c 

    from table_name etc.
    I would like to format the output so that it appears as follows:     

    columna
    columnb
    columnc     

    So, I need to concatenate the newline command. (\n) at the end of = the first two columns.

    The problem is that if I just coincatenate the newline command, the = output I get is

    just columna\n columnb\n columnc\n.     Does anyone know how I can achieve this?

Received on Wed May 26 1999 - 12:43:54 CDT