Re: Replace a return in a string

You can use

update mednet.contact set con_info = replace(con_info, CHR(13));

To remove linefeeds, you can use CHR(10).

Marc

Wolf Jürgen wrote in message <8c1lop$hjt$1_at_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 - 02:42:25 CST