${if(len(WORK)=0,"","and replace(t.ACCOUNT_YEAR_MONTH,'-','') between '"+left(WORK,4)+"01' and '"+replace(WORK,'-','')+"'")}

你数据库的数据长啥样啊

1月、2月这样的么？

SELECT sum(MAIN_OUTPUT*1000) as TCBBCKFROM ZL_REPORT_FORM twhere 1=1${if(len(WORK)=0,"","and substr(t.ACCOUNT_YEAR_MONTH,1,4) = '"+left(WORK,4)+"'")}${if(len(WORK)=0,"","and substr(t.ACCOUNT_YEAR_MONTH,6,2) <= '"+right(WORK,2)+"'")}AND ITEM_CODE = 'ZL006'