Re: Help with carriage return in varchars

Don't use carraige returns [CHR(13)], use line feeds [CHR(10)]

INSERT INTO the_table (the_column)
  VALUES ('Two'||CHR(10)||'Lines');

Best!

Randall

essbee <spare_brain_at_yahoo.com> wrote in message news:yjYO6.41024$4f7.3048876_at_bgtnsc06-news.ops.worldnet.att.net...
> Could someone please provide some advise on how to store a carriage-return
> (like \n in C++) in a VARCHAR2 field?
>
> Thanks!
>
> essbee
>
>
Received on Sat Jul 21 2001 - 16:43:01 CDT