Re: How do I insert a carriage return and a line feed into a column?
From: Tomm Carr <carr%tw_at_edwards.af.mil>
Date: 1997/08/29
Message-ID: <340753C9.12C0_at_edwards.af.mil>#1/1
Date: 1997/08/29
Message-ID: <340753C9.12C0_at_edwards.af.mil>#1/1
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_at_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.Received on Fri Aug 29 1997 - 00:00:00 CEST