Re: How do I insert a carriage return and a line feed into a column?

L. Tseng wrote:
>
> I was wondering how a carriage return and a line feed
> can be inserted into a varchar2(255) column so
> the text will be in certein format when retrieved.

'line 1' || chr(13) || chr(10) || 'line 2'

-- 
Tomm Carr  --> Note new e-mail address
tommcatt@computer.org -- http://www.geocities.com/athens/delphi/6769
-- The Macintosh computer is like the open range;
-- In a world without fences, there are no Gates.