case when brh.city_branch_no = '430100' then '长沙'
when brh.city_branch_no = '430200' then '株洲'
when brh.city_branch_no = '430300' then '湘潭'
when brh.city_branch_no = '430400' then '衡阳'
when brh.city_branch_no = '430500' then '邵阳'
when brh.city_branch_no = '430600' then '岳阳'
when brh.city_branch_no = '430700' then '常德'
when brh.city_branch_no = '430800' then '张家界'
when brh.city_branch_no = '432300' then '益阳'
when brh.city_branch_no = '432500' then '娄底'
when brh.city_branch_no = '432800' then '郴州'
when brh.city_branch_no = '432900' then '永州'
when brh.city_branch_no = '433000' then '怀化'
when brh.city_branch_no = '433100' then '湘西'
end as city
when brh.city_branch_no = '430200' then '株洲'
when brh.city_branch_no = '430300' then '湘潭'
when brh.city_branch_no = '430400' then '衡阳'
when brh.city_branch_no = '430500' then '邵阳'
when brh.city_branch_no = '430600' then '岳阳'
when brh.city_branch_no = '430700' then '常德'
when brh.city_branch_no = '430800' then '张家界'
when brh.city_branch_no = '432300' then '益阳'
when brh.city_branch_no = '432500' then '娄底'
when brh.city_branch_no = '432800' then '郴州'
when brh.city_branch_no = '432900' then '永州'
when brh.city_branch_no = '433000' then '怀化'
when brh.city_branch_no = '433100' then '湘西'
end as city