需求:判断资金端是否没空,当不为空时进行代码=>中文的转义
CASE
WHEN a.capital_no IS NOT NULL THEN
CASE
WHEN a.capital_no = 'XHQBZJF001' THEN
'小贷'
WHEN a.capital_no = 'XHQBZJF002' THEN
'启浩保理'
WHEN a.capital_no = 'XHQBZJF003' THEN
'国民信托'
ELSE
a.capital_no
END
WHEN b.capital_no IS NOT NULL THEN
CASE
WHEN b.capital_no = 'XHQBZJF001' THEN
'小贷'
WHEN b.capital_no = 'XHQBZJF002' THEN
'启浩保理'
WHEN b.capital_no = 'XHQBZJF003' THEN
'国民信托'
ELSE
b.capital_no
END
WHEN c.capital_no IS NOT NULL THEN
CASE
WHEN c.capital_no = 'XHQBZJF001' THEN
'小贷'
WHEN c.capital_no = 'XHQBZJF002' THEN
'启浩保理'
WHEN c.capital_no = 'XHQBZJF003' THEN
'国民信托'
ELSE
c.capital_no
END
END capital_no
注:
case when then end 结构必须配套!
CASE
WHEN…… THEN……
(ELSE……)
END