地区匹配

select xkzh, qymc,zcdz,fzjg From nmpa_cust order by xkzh

select top 10000 substring(xkzh,1,1) as sfjc,xkzh,qymc,zcdz,substring(zcdz,1,charindex('省',zcdz)) as sfmc,
substring(zcdz,1,charindex('市',zcdz)) as sjmc1,
substring(fzjg,1,charindex('市',fzjg)) as sjmc2 From nmpa_cust