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

In article <3i2jfa$2tr_at_athos.cc.bellcore.com> parris_at_walleye.esp.bellcore.com (Parris Geiser) writes:
>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:

This might work:?

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

The chr(10) translate 10 into ascii which is a new line. Have fun.

> 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?

-- 
((((((((((((((((((((((((((((((((((((((((*))))))))))))))))))))))))))))))))))))))
rvele_at_ctp.com  |   Cambridge Technology Partners       | 
Raymond Velez  |   304 Vassar St, Cambridge, MA        | WORK: (617)374-8399
((((((((((((((((((((((((((((((((((((((((*))))))))))))))))))))))))))))))))))))))