Carriage Return

From: Allan Martin <allan.martin_at_saic.com>
Date: Tue, 4 Dec 2001 12:01:44 -0000
Message-ID: <3c0c4aa9$1_at_cpns1.saic.com>



Hi,

[Quoted] Does anyone know how to insert a Carriage Return into a field with a datatype of LONG.

I was working along the lines of:

update tblname set longfield = longfield || chr(13) || 'my new line' where pk = 'Martin';
commit;

but I'm getting back an inconsistent datatype.

Thanks in advance,

Allan Martin Received on Tue Dec 04 2001 - 13:01:44 CET

Original text of this message