Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Replace a return in a string

Replace a return in a string

From: Wolf Jürgen <a9502845_at_unet.univie.ac.at>
Date: Fri, 31 Mar 2000 10:02:52 +0100
Message-ID: <8c1lop$hjt$1@fleetstreet.Austria.EU.net>


Hello

a little question:
How do I filter a "return" out of a varchar2-field all over the database:

update mednet.contact set con_info = replace(con_info, '???', ' ');

what do I have to write for ??? to find a return in a string.

Greetings Wolf Received on Fri Mar 31 2000 - 03:02:52 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US