Re: ?? How to get newlines in text ??

Parris Geiser (parris_at_walleye.esp.bellcore.com) wrote:
: I have a varchar column in a table that my users would like to place
: "formatted" text, i.e., text that contains newlines.
: So, for example, what I would like to do is:
: insert into MyTable values ('First line \n Second line');
: Then, when I do the select:
: select col from MyTable;
: I get the output that looks like:
: First line
: Second line
 

: Does anyone have an idea on how to accomplish this?

Try using:

insert into test_table values ('First Line' || chr(10) || 'Second line');

We use the a lot

Brian Stanek
Profound Consulting Received on Sat Feb 18 1995 - 02:14:18 CET