Re: Decode based on two fields

From: Ken Madsen <madsenkj_at_pe-nelson.com>
Date: 1998/08/13
Message-ID: <35D34711.6B10EAA5_at_pe-nelson.com>#1/1

One way is to try concatenation...

DECODE(SchoolCode||Major, 'GR'||'CS', 'SS', 


                          'GR'||'BA', 'BU',


                          'GR'||'MBA', 'BU')



Of course, you can choose to use 'GRCS' instead of 'GR'||'CS', but

placing the concatenation operation makes it clear when reading the code where the split occurs in the individual field values.

(Line breaks inserted for readability also)

-- 
Ken Madsen

Received on Thu Aug 13 1998 - 00:00:00 CEST