Re: How to convert carriage return character to space?

From: Bernard Polarski <bpolarsk_at_yahoo.com>
Date: Wed, 22 Dec 1999 08:10:09 GMT
Message-ID: <83q110$5n2$1@nnrp1.deja.com>

Try :

Begin

select translate(my_field,char(10),char(32)) into my_var_string from mytable

end ;

Regards

B. Polarski
http://www.geocities.com/bpolarsk
Email:bpolarsk_at_yahoo.com

In article <83pmo9$v88$1_at_nnrp1.deja.com>, veronicahlee_at_my-deja.com wrote:
> Hello,
>
> I am encountering problems with carriage return character (displayed
in
> Oracle as thick vertical bar) in the data.
> If anyone knows how to convert it to space, I'd appreciate it.
>
> Veronica
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

--
B.Polarski

http://www.geocities.com/bpolarsk
Email : bpolarsk_at_yahoo.com

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Dec 22 1999 - 02:10:09 CST