select d.sout_no,t.tax_price,t.tax_money,t.sout_num,round(t.sout_num*t.tax_price,2) as mo from t_srp_store_out_bhdtl t
left join t_srp_store_out d on d.sout_id=t.sout_id
where ( LENGTH(T.TAX_PRICE)-instr(T.TAX_PRICE,'.')>4 and instr(T.TAX_PRICE,'.')>0)
关键语句
( LENGTH(T.TAX_PRICE)-instr(T.TAX_PRICE,'.')>4 and instr(T.TAX_PRICE,'.')>0)
效果
![在这里插入图片描述](https://img-blog.csdnimg.cn/20200528103427432.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQzNTExNjc3,size_16,color_FFFFFF,t_70)