Re: line breaks

Try this:

select 'Text 1'||chr(10)||'Text 2'
from dual;

You can replace the chr(10) with whatever is appropriate for your OS.

Larry

In article <8ea52s$lim$1_at_nnrp1.deja.com>,   baoba_at_my-deja.com wrote:
> I have written a mail program for my company that allows the user to
> select several items to be added to a list.I am concatenating several
> varchar2's and want a line break at the end of each one. I have tried
> <BR> and \n and don't know where to go from there. If anyone could
 help
> it would be appreciated.
> peter
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Apr 27 2000 - 00:00:00 CEST