select distinct CASE WHEN LEN(syxh) > 10 THEN '南' ELSE '北' END AS yq,syxh,czrq,hzxm,bqmc,zypjg,znl,zdbz,zzf,ztshhw,jlzt,sfrq,ysdmfrom YYK_YPJGK (nolock)WHERE 1=1 ${IF(LEN(czrq)==0,"","and convert(nvarchar(10),czrq,120 )='"+czrq+"'")} ${if(len(jlzt)=0,"","and jlzt='"+ jlzt + "'")}order by czrq desc