Re: NewLine with SQL

In article <9pc8eg$1b72$1_at_news6.isdnet.net>, DBA Casino Monté-Carlo says...
>
>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
>
>

Depending on the OS you have its something like:

chr(10) || chr(13)

Hth
Matthias Received on Tue Oct 02 2001 - 08:02:03 CDT