字符串的截取

update a set wcflag=2,a.typeno1=b.typenos,a.typename=b.mname,a.notypesprc=b.csprc,--a.typesprc=b.sprc,
a.typesprc=
        case when isnull(b.long,0)=0 and isnull(b.mm,0)=0 then b.sprc 
        when isnull(b.long,0)=0 and isnull(b.mm,0)<>0 then b.sprc+ '-L'+cast(cast(b.mm*1000 as  float)  as varchar)
        when isnull(b.long,0)<>0  then b.sprc+ '-L'+cast(cast(b.long*1000 as  float)  as varchar) end,
        a.qty=b.qty,a.typeunits=b.units,a.zk=b.lvdis,a.qtzk=b.bzk,a.sqzk=b.bzk,a.zkl=b.feerate,a.zkprice=b.price,a.tprice=b.days, 
        a.remark=b.remark,a.taxprice=b.taxprice,a.taxmoneys=(case when isnull(a.billno,'')<>'' then round(b.qty*b.taxprice,2) else round(b.qty*b.price*1.13,2) end),
        a.pic=b.pic,a.mcode=(case when isnull(a.mcode,'')='' then b.mcode else a.mcode end),a.long=(case when isnull(b.typeno,-1)=1 then b.mm  else b.long end)
            from sa_webbaojlist a  inner join sa_askpricelist b  on a.billno=b.billno and a.autoid=b.iid
            where b.askno=@askno and  a.autoid=b.iid