Re: Searching for newline characters in a varchar

From: Tina Tran <tinat_at_sonica.com>
Date: 1997/10/09
Message-ID: <01bcd4d8$23c8fc10$2aaeb6cc@dino>#1/1

select replace(myvar,chr(10),my_replacement) from dual;

Replace myvar with your variable
Replace my_replacement with a character or string that you want to put in place of newline.

Bryan J. Gentile <bgentile_at_bdsinc.com> wrote in article <343CE0E1.79244B65_at_bdsinc.com>...
> I want to find out how I can search through a variable of type varchar
> and replace newline characters with something else. (PL/SQL)
>
> --
> **************************************
> Bryan J. Gentile
> Consultant
> Business Data Services, Inc.
> Glastonbury, CT 06033
> Phone: (860) 633-3693 (ext. 3006)
> Vmail: (ext. 6030)
> **************************************
>
>
>
Received on Thu Oct 09 1997 - 00:00:00 CDT