My query is like this
我的查询是这样的。
declare @searchWord varchar(100)
set @searchWord = 'carb9'
declare @tableWord varchar(100)
set @tableWord = 'Racing Carb9 uretor'
--set @tableWord = 'carb9'
select 1
where @tableWord like '%[^a-z0-9]' + @searchWord + '[^a-z0-9]%'
or @tableWord like @searchWord + '[^a-z0-9]%'
or @tableWord like '%[^a-z0-9]' + @searchWord
declare @s