工作中

select ID,BH,BM,SPBM,d.dictmean as MZ,DZMZ,YE,SITES,SITE_LY,SITE_HS,to_char(FQRQ,'yyyy-mm-dd') as FQRQ,to_char(HSRQ,'yyyy-mm-dd') as HSRQ,FLAG from INTO_COUPONS c left join sys_dict2 d  on c.mz = d.dictno and d.mainno = 3042

--{$IFDEF MZ$} 
and c.MZ  like '%##MZ%'
--{$ENDIF MZ$}

--{$IFDEF BH$} 
and c.BH  like '%##BH%'
--{$ENDIF BH$}