AnsweredAssumed Answered

Carriage Return in a CLOB field?

Question asked by Chris_Shaffer_hcsc on Mar 5, 2009
Latest reply on Mar 5, 2009 by sivasairam
I didnt know which sub-forum to stick this in so I went to the good ol GEL forum.     I have a "Large String" (CLOB) attribute that I am wanting to write to. It will serve as an audit of what has happened and populated by a process.     Update niku . ODF_CA_REQUISITION  Set itg_reqhistory = '03/3/09 Line 1'  Where ID = 5033003 ;     Commit;        Update niku . ODF_CA_REQUISITION  Set itg_reqhistory = itg_reqhistory || chr(10) || '03/3/09 Line 2'  Where ID = 5033003 ;        Commit;      I get the following when displayed in Clarity.   03/3/09 Line 1   03/3/09 Line 2     How can I get rid of that space before line 2? I have tried everything I could think of including trimming and taking off the first character with no luck. When I look at the actual HTML code of the text on the screen I see..     Requisition History 03/3/09 Line 1 > 03/3/09 Line 2