help with DECODE

From: Patrick Drouin <patrick.drouin_at_nortel.com>
Date: 1997/09/24
Message-ID: <3429244B.24EA@nortel.com>#1/1

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 Received on Wed Sep 24 1997 - 00:00:00 CDT