declare @m varchar(max)
set @m='1,3'
select 旅游目的地
from dbo.业务_产品
where exists(select 1 from (select a from dbo.f_split(旅游目的地,',')) as A join (select a from dbo.f_split(@m,',')) as B on A.a = B.a)
set @m='1,3'
select 旅游目的地
from dbo.业务_产品
where exists(select 1 from (select a from dbo.f_split(旅游目的地,',')) as A join (select a from dbo.f_split(@m,',')) as B on A.a = B.a)
