How to trim the carriage return?

From: Tony Lai <tonylai_at_consultant.com>
Date: Tue, 3 Apr 2001 00:27:11 +0800
Message-ID: <9ackcs$g0k2_at_imsp212.netvigator.com>


Dear all,

In my Oracle 7 database, there is varchar2 column where the data consist of carriage return. Now, if I want to extract that column with all the carriage return replaced by a space, what should I do to accomplish that?

Any idea follow-up here or email to me are very much appreciated

Thanks alot...

--

Best Regards,

Tony Lai
Email                 :  tonylai_at_consultant.com
Mobile Tel. No. :  6018-0411
Received on Mon Apr 02 2001 - 18:27:11 CEST

Original text of this message