Re: trivial decode NOT
Date: 1995/04/11
Message-ID: <michaelx.28.001408F9_at_leland.stanford.edu>#1/1
In article <D6L1J7.KBq_at_gremlin.nrtc.northrop.com> maurit_at_world.nad.northrop.com (Mark W. Aurit) writes:
>From: maurit_at_world.nad.northrop.com (Mark W. Aurit)
>Subject: trivial decode NOT
>Date: Wed, 5 Apr 1995 22:09:06 GMT
>Im creating a view, and need to add a new column "Acct_Desc".
>The pseudo code behind the new column is (roughly)
>if acct ge '120' and acct le '140' then 'Labor'
>if acct ge '150' and acct le '160 or
> acct ge '170' and acct le '180' then 'Fringe'
>.. and on and on, but you get the idea
>Would greatly appreciate any help on how to do this in a decode
>(unless anyone knows any other ways!)
>Mark
>maurit_at_world.nad.northrop.com
>--
>Mark Aurit
>Finance Client/Server Systems
>Northrop Grumman Data Systems (West)
>maurit_at_world.nad.northrop.com
If your workstation is a PC check out either Cognos's Impromptu, or Nomad's
Front and Center, Professional version. Both allow very complicated if then
else virtual element constructs. Much Much easier than trying to use nested
decodes or creating views.
Michael Barbitta Received on Tue Apr 11 1995 - 00:00:00 CEST