Re: NewLine with SQL

From: AJ <dapcourt_at_bluecarrots.com>
Date: Tue, 2 Oct 2001 22:15:30 +0100
Message-ID: <3bba2cbf_2@news1.vip.uk.com>

"DBA Casino Monté-Carlo" <p.hirth_at_sbm.mc> wrote in message news:9pc8eg$1b72$1_at_news6.isdnet.net...
> Hi,
>
> Someone could tel me how can i do to insert a NewLine Character in a :
>
> select "myString," || NewLine || myString2 from toto;
>
> result is : myString,
> myString2
>
> Thank's
>
>

If your linesize is, say, 132, you could do something along the lines of :

select rpad("myString",131), myString2 from toto;

Not very fancy, but it'll do the job consistently across platforms.

AJ. Received on Tue Oct 02 2001 - 16:15:30 CDT