将但单位的金额分开表示

 select SUBSTRING(zhiwei,1,CHARINDEX('万',zhiwei)-1) as lll ,
         SUBSTRING(zhiwei,CHARINDEX('万',zhiwei)-1,10000) as sssss,
		zhiwei
  from job where zhiwei='100万人民币' or zhiwei='100.57643万人民币'