SqlServer_去空值模糊查询

sql

select count(1)  from t_table  where name like '%'+ltrim(rtrim('  testName'))+'%'

select count(1)  from t_table  where name like '%  testName%'
select count(1)  from t_table  where name like '%testName%'

result

100
0
100

---

replace(colName,’ ‘,’’)