Re: How to trim the carriage return?
From: Mark Malakanov <markmal_at_home.com>
Date: Thu, 05 Apr 2001 18:36:24 GMT
Message-ID: <IW2z6.27836$XV.7164188_at_news3.rdc1.on.home.com>
Date: Thu, 05 Apr 2001 18:36:24 GMT
Message-ID: <IW2z6.27836$XV.7164188_at_news3.rdc1.on.home.com>
select translate(col1,chr(10),' ') from tab1;
-- ----------------------------------------------------- Thanks, Mark "Tony Lai" <tonylai_at_consultant.com> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: news:9ackcs$g0k2_at_imsp212.netvigator.com...Received on Thu Apr 05 2001 - 20:36:24 CEST
> 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
>
>
>
>