Re: trivial decode NOT
Date: 1995/04/17
Message-ID: <3muag3$nkj_at_cardinal.fs.com>#1/1
Mark W. Aurit (maurit_at_world.nad.northrop.com) wrote:
: 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
Mark,
Try using embedded SIGN statements to evaluate the above if. It will be quite a DECODE! But I feel it is possible. Let me know, either way, ie. if it works or not.
Kannan
skannan_at_fs.com
Received on Mon Apr 17 1995 - 00:00:00 CEST