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

Try CHR(10) or CHR(13) or a combination of both for your requirement.

HTH Prasad Chavali
pchavali_at_assettech.com

Reid Lai wrote in message <3630A46A.2BAC2173_at_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 - 11:12:08 CDT