trivial decode NOT

From: Mark W. Aurit <maurit_at_world.nad.northrop.com>
Date: 1995/04/05
Message-ID: <D6L1J7.KBq_at_gremlin.nrtc.northrop.com>#1/1

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

Received on Wed Apr 05 1995 - 00:00:00 CEST