用数据库NORTHWND.MDF
declare @x nvarchar(50)
set @x='Soft drinks'
select * from dbo.Categories
where Description like '%'+@x+',%' or Description like '%,'+@x+'%'
or Description like '%,'+@x +',%' or Description like '%'+@x +'%'
结果:
用数据库NORTHWND.MDF
declare @x nvarchar(50)
set @x='Soft drinks'
select * from dbo.Categories
where Description like '%'+@x+',%' or Description like '%,'+@x+'%'
or Description like '%,'+@x +',%' or Description like '%'+@x +'%'
结果: