Re: How to trim the carriage return

From: Scott Mattes <ScottMattes_at_yahoo.com>
Date: Tue, 03 Apr 2001 15:34:41 GMT
Message-ID: <l4my6.7069$%N.57910_at_skycache.prestige.net>


Try the translate function.

"Tony Lai" <tonylai_at_consultant.com> wrote in message news:9ackcr$g0k1_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
>
>
>
Received on Tue Apr 03 2001 - 17:34:41 CEST

Original text of this message