模糊查询忽略数据库字段中的空格
表结构
select * from dbo.Table2 tb
where (select replace(name,' ','') from dbo.Table2 tbs where tb.name=tbs.name) like '%上海上海市
表结构
select * from dbo.Table2 tb
where (select replace(name,' ','') from dbo.Table2 tbs where tb.name=tbs.name) like '%上海上海市