Mysql case when then end语句 select里面判断语句

--insert into tb_label(rel,pn,dc,vdet,lot1,qty1,ewm,declar,dingdan) 
select 
	wp.tf_rel rel,
	label.tf_text_c pn,
	(case when mark.tf_yw != null then
		mark.tf_yw  
	else
		substring(wp.tf_rel,2,4)
	end )dc,
	mark.tf_pro+' '+mark.tf_yw vdet,
	case when len(plans.tf_jybph) > 5 then 
		plans.tf_jyaph+'/'+plans.tf_jybph 
	else 
		plans.tf_jyaph 
	end lot,	
	cast(sum(wp.tf_qty1+0)+sum(wp.tf_qty2+0) as varchar(20))+'PCS' qty,
	label.tf_text_c+'|'+ 
	cast(sum(wp.tf_qty1+0)+sum(wp.tf_qty2+0) as varchar(20))+'PCS' + '|' + 
	(case when len(plans.tf_jybph) > 5 then 
		plans.tf_jyaph+'/'+plans.tf_jybph 
	else 
		plans.tf_jyaph 
	end )+ '|' + 
	mark.tf_yw 
 	ewm,
	label.tf_text_g declar,
	plans.tf_dingdan dingdan 
		from 
			tb_dqfn_wp11 wp,
			tb_dqfn_plan_label label,
			tb_dqfn_plan_marking mark,
			tb_dqfn_plan plans, 
			tb_dqfn_plan_bom bom 
				where wp.tf_dingdan = label.tf_id and 
				wp.tf_dingdan = mark.tf_id and 
				bom.tf_dingdan = plans.tf_dingdan and 
				wp.tf_dingdan = plans.tf_id and 
				--wp.tf_prFlag = 'N' and 
				plans.tf_dingdan = '4700291158'
	group by  label.tf_text_g,wp.tf_rel,label.tf_text_c,label.tf_text_d,plans.tf_p3,plans.tf_jyaph,label.tf_text_e,plans.tf_dingdan,mark.tf_yw ,mark.tf_pro,plans.tf_jybph	 
	order by wp.tf_rel