Re: decode(sth,sth>3,null,sth)-does anybody try ...
From: LokalST <stbest001_at_hotmail.com>
Date: Thu, 28 Mar 2002 16:51:19 +0100
Message-ID: <a7vdlg$kmb$1_at_sunce.iskon.hr>
Date: Thu, 28 Mar 2002 16:51:19 +0100
Message-ID: <a7vdlg$kmb$1_at_sunce.iskon.hr>
"mariusz" <on_at_wp.pl> wrote in message news:a7vcqu$hgj$1_at_news.tpi.pl...
> Hi,
> decode(sth,sth>3,null,sth)-does anybody try anything like this?
> Is there any others easy whay to code like that?
Maybe this?
If sth> 3 then sign (sth-1) will be 1 and You get null,else,You get sth.
Decode(sign(sth-3),1,null,sth)
Hope this help.
Received on Thu Mar 28 2002 - 16:51:19 CET