LONG Column Question

[Quoted] We have a Field which was a datatype with Varchar2(2000)...we used to Load data thru SQL*Loader into the Field applying the function "replace(:<field>,'^M','chr(10)||chr(13)')" [Quoted] This was due to the fact that Data came in thru the Web-form/email, etc and had a ^M....which we translated [Quoted] into the a New Line so that Data appears in proper format on the GUI Screen.

[Quoted] WE had a Business Requirement and Have to Change this Field to a LONG Field... [Quoted] How do we take care of the ^M replacement...since we cannot apply the replace function during or after [Quoted] the load of data....The Data without the above comes in one contiuous line...

[Quoted] Any help/pointer is appreciated.

TIA,
Bg Received on Tue Mar 07 2000 - 00:19:17 CET