Re: How Do I insert a Carriage Return in a String?

From: Reid Lai <reidlai_at_hk.super.net>
Date: Fri, 23 Oct 1998 23:44:42 +0800
Message-ID: <3630A46A.2BAC2173@hk.super.net>

Find out the ascii code value and concat them with CHR function.

Eric Jodoin wrote:

> Hi.
>
> I would like to know How I can Insert a Carrige return in a string that
> will ultimately end up in a large VARCHAR2
>
> Here is an Exemple:
>
> FIELD1|| 'CR LF'||FIELD2
>
> 'CR LF' Should =be a Line Feed - carriage Retrun...
>
> Thanks.

--
Best Regards,

Reid Lai <reidlai_at_hk.super.net>
Certified Oracle 7.3 DBA (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Fri Oct 23 1998 - 10:44:42 CDT