如:
select * from [table1] where [field1] like ‘%test%’
可以用如下语句代替:
select * from [table1] where charindex('test', [field1]) > 0
如:
select * from [table1] where [field1] like ‘%test%’
可以用如下语句代替:
select * from [table1] where charindex('test', [field1]) > 0