不能对 varchar 调用方法，是什么原因？

【myApps/OBPM版本号】：4.4stable sp21
【浏览器类型】：Chrome
【技术QQ群】：182378297
【场景】：

1. select '"+getDomainid()+"' AS domainid,s.xmbh,s.xmmc,s.bmbh,s.isedkz,s.fzr,(SELECT sum(ncye) FROM zwxmje WHERE xmbh = s.xmbh AND kjqj = '01' GROUP BY xmbh ) AS ncye,(SELECT sum(dje) FROM zwpzfl WHERE xmbh = s.xmbh AND s.pznm.substring(0,2)='"+yearmd+"' and kmbh LIKE '9%' GROUP BY xmbh) AS xmys,(SELECT sum(jje) FROM zwpzfl WHERE xmbh = s.xmbh AND kmbh NOT LIKE '9%' GROUP BY xmbh) AS xmzc from (SELECT zwxmzd.xmbh,zwxmzd.xmmc,zwxmzd.bmbh,zwxmzd.isedkz,zwxmzd.fzr,zwpzfl.pznm FROM (zwxmzd LEFT JOIN zwpzfl ON zwpzfl.xmbh = zwxmzd.xmbh) LEFT JOIN zwxmje ON zwxmje.xmbh = zwxmzd.xmbh WHERE zwpzfl.bmbh = '"+xbmbh0+"' and zwxmzd.fzr='"+userName+"') s group by s.xmbh,s.xmmc,s.bmbh,s.isedkz,s.fzr,s.pznm

复制代码

1. [42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]不能对 varchar 调用方法。 (258)

复制代码

【解决方法】：


将框选的替换成以下