Re: Searching for newline characters in a varchar

From: Matthias Gresz <GreMa_at_t-online.de>
Date: 1997/10/14
Message-ID: <61vl8s$8hu$1@news02.btx.dtag.de>#1/1

Bryan J. Gentile wrote:
>
> 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)
> **************************************
Hi,

try

SUBSTR(string,1,INSTR(string,chr(13))-1) || newchar ||SUBSTR(string,INSTR(string,chr(13)) + 1,length(string))

-- 
Regards

M.Gresz    :-)

Received on Tue Oct 14 1997 - 00:00:00 CDT