报表制作sql语句，模糊查询

Question

select [BinnId],[Code],[BoxCode],[SCode],[CreateName],[CreateTime] from dbo.Logistics_Binn
where len(SCode)-len(replace(SCode,',',''))!=8 ${if(len(p1)==0,"","and SCode collate Chinese_PRC_CS_AS like '%"+p1+"%' or BoxCode collate Chinese_PRC_CS_AS like '%"+p1+"%'")}
模糊查询这个or用在这里好不好

Answer 1

可以在数据库里面执行以下看一下效果啊