Re: Linefeed

open sql+ and try

select '1'||chr(10)||'2' from dual;
and
select '1'||chr(13)||'2' from dual;
You'll see which one give a usable result. It's definitively the first ;-)

On Wed, 7 Jun 2000 20:30:26 -0700, "Matt B." <mcb_at_fightspam.sd.znet.com> wrote:

>"Stian Kaasa" <stian.kaasa_at_caa.no> wrote in message
>news:j_4%4.20737$C9.394353_at_news1.online.no...
>> Hi
>>
>> Does anyone know how to insert Line Feeds into a text ?
>> Example: :NEW.HISTORY := CONCAT(:NEW.HISTORY,--want an escape sequence for
>> LF here--);
>>
>> Appreciate any help
>>
>> Stian Kaasa
>
>A chr(10) is a carriage return. I think a chr(13) is a line feed (can't quite
>remember). Anyway, here's a carriage return example:
>
>:NEW.HISTORY := :NEW.HISTORY || chr(10);
>
 

-- 
Luc Bosman
DEV/2000 Software Engineer
Database and Network Administrator
l.bosman_at_wanadoo.be
ICQ 37011625          http://users.skynet.be/kobukai/
 ---------------------------------------------------- 
|  -°)                                          (°-  |
|  /\\  Linux the choice of the GNU generation  //\  |
| _\_v                                          v_/_ |
 ----------------------------------------------------