Carriage Return

Hi,

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 - 06:01:44 CST