SELECT A.FJOBID,MIN(A.FLSTUPDTIME),
SUBSTR(B.FBIN,1,4)||'-'||(case when (substr(b.fbin,5,2)) in (1,2,3,4,5,6) then '1' else '2' end ),
COUNT(B.FARTICLE),SUM(B.FQTY),SUM(B.FQTY*C.FPRICE)
   FROM TPICKUP A,TPICKUPDTL B,TARTICLE C
  WHERE A.NUM = B.NUM
    AND B.FARTICLE = C.FGID
    AND A.FPICKAREA = 20


fbin这个字段内容如：20010101
我现在想substr(fbin,4,1) in　奇数，则执行 case when substr(fbin,5,2) in (1,2,3,4) then ‘上半段’else　‘下半段’
substr(fbin,4,1) in 偶数，则执行case when substr(fbin,5,2) in (1,2,3,4，5，6，7，8) then ‘上半段’else　‘下半段’
应如何写呢

select fbin,
case  when (substr(fbin,4,1)) in (1,3,5,7,9)  and (substr(fbin,5,2)) in (1,2,3,4) then '1'
      when (substr(fbin,4,1)) in (1,3,5,7,9)  and (substr(fbin,5,2)) in (5,6,7,8,9,10,11,12) then '2'
      when (substr(fbin,3,2)) in (2,4,6,8,10)  and (substr(fbin,5,2)) in (1,2,3,4,5,6,7,8) then '1'
       when (substr(fbin,3,2)) in (2,4,6,8,10)  and (substr(fbin,5,2)) in (9,10,11,12) then '2'
           end
  from tpickupdtl

没有人会吗，上面那样写可不可以