create proc find_p as
declare @sql varchar(100)
set @sql = '空格,符号,分隔,并串,起来,关键'
..
select * from tb where contains(@sql,Column1)
declare @sql varchar(100)
set @sql = '空格,符号,分隔,并串,起来,关键'
..
select * from tb where contains(@sql,Column1)
set @a='ss sfsf 好的 rwer sfw 2333' declare @t table(a varchar(10))
insert @t
select 'ss' union all
select 'sfsf' union all
select 'sfw' union all
select '好的' union all
select '没有啊' union all
select 'kao' select * from @t where charindex(a, ' '+@a+' ')<>0