Convert SQL server case statement to Oracle

From: Cale, Rick T (Richard) <RICHARD.T.CALE_at_saic.com>
Date: Mon, 30 Oct 2000 11:58:35 -0800
Message-Id: <10665.120596@fatcity.com>

Hi All,

I am trying to convert the following case stmt to Oracle but am stuck. I tried using DECODE but cannot
handle the <= or <. Equal or Not equal I can convert by using decode. Any ideas?

Thanks
Rick

WHEN	EFF_DATE <= V_dStartDate  AND END_DATE_ADJ <= V_dEndDate
   THEN	COMP_LINK_EMIS_ADJ*DATEDIFF(SS,V_dStartDate

,END_DATE_ADJ)/3600*(OP_PCT/100) WHEN (EFF_DATE BETWEEN V_dStartDate AND V_dEndDate) AND END_DATE_ADJ >= V_dEndDate

   THEN COMP_LINK_EMIS_ADJ*DATEDIFF
(SS,EFF_DATE,V_dEndDate)/3600*(OP_PCT/100)

WHEN (EFF_DATE BETWEEN V_dStartDate AND V_dEndDate) AND (END_DATE_ADJ  BETWEEN V_dStartDate AND V_dEndDate)
   THEN
COMP_LINK_EMIS_ADJ*DATEDIFF(SS,EFF_DATE,END_DATE_ADJ)/3600*(OP_PCT/100)

WHEN	(EFF_DATE < V_dStartDate) AND (END_DATE_ADJ > V_dEndDate)
	THEN
COMP_LINK_EMIS_ADJ*DATEDIFF(SS,V_dStartDate,V_dEndDate)/3600*(OP_PCT/100)
ELSE	0

Thanks
Rick

Rick Cale, Science Applications International Corp. Phone:865-481-2198, fax:865-481-8555 Received on Mon Oct 30 2000 - 13:58:35 CST