where patindex('%张%',col1)>0
string sql="select * from tb where 1=1";
sql+=条件?" and 字段 like '% %'":"";
sqlparameter
select * from tb WHERE Name LIKE '%'+@Name+'%'
string sql="select * from tb where 1=1";
sql+=条件?" and 字段 like '% %'":"";
sqlparameter
select * from tb WHERE Name LIKE '%'+@Name+'%'
select * from tb where name like '%张%'
parm.Value = "%"+name+"%";