模糊查询

VS中 cs代码
string condition = "and title like '%" + title + "%'"; //title为变量
VS中dataset中

select * from tbName where title like

sql查询分析器

select * from tbName where title like '%临街%'

存储过程  

exec sp_tt ' title like ''%临街%'' ' --调用存储过程(附加sql语句)

避免like 查错