try chr(10)||chr(13)
do you need both ??? not if you're on a PC.
Thor HW
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 Mon Oct 26 1998 - 02:16:01 CST
