Re: help with DECODE

From: Ed Bradt <ebradt_at_lilly.com>
Date: 1997/09/24
Message-ID: <34295852.63BC@lilly.com>#1/1

Patrick Drouin wrote:
>
> Hello everyone,
>
> Simple and stupid question but I can't figure it out : How do I perform
> multiple decode on a simple VARCHAR2 field? I have a field that contains
> both TAB and CR and I want to filter them out. I use the following to
> get rid of the unwanted CRs, I do I go about to get both TABs and CRs
> out?
>
> select replace(description,chr(10),' ') from texte....
>
> Any suggestion is welcome!
> Ciao, Patrick

just used nested replace calls:
select replace(replace(description,chr(10),' '),chr(xx),' ') Ed Bradt Received on Wed Sep 24 1997 - 00:00:00 CDT