你可以试试这个...
在SQL Server 2012以下版本中：-

DECLARE @string NVARCHAR(100) = '12,14,15,1,2'
    ;WITH cte AS
    (
       SELECT 
          CAST('<XMLRoot><RowData>' + REPLACE(t.val,',','</RowData><RowData>') + '</RowData></XMLRoot>' AS XML) AS x
          FROM (SELECT @string) AS t(val)
    ),
    ct as (
    SELECT 
        m.n.value('.[1]','varchar(8000)') as col
    FROM cte
    CROSS APPLY x.nodes('/XMLRoot/RowData')m(n)
    ),
    ctfinal as (
          SELECT CASE WHEN CAST(col AS int) IN ( 1,2) THEN 1 ELSE 0 END AS RES FROM ct 
    )
    SELECT TOP 1 FROM ctfinal ORDER BY RES DESC

或

declare @Class varchar(20) 
    set @Class = '4,6,8,1'

    select 
        case when (@Class like '%1%' or @Class like '%2%')
                then 1 
                else 0 
        end

对于SQL Server 2012及更高版本：-

declare @Class varchar(20) 
    set @Class = '4,6,8,1'

    ; with cte as (
    select case when value in (1, 2) 
    then 1 else 0 end as res 
    from STRING_SPLIT ( @Class , ',' )
    ) 
    select top 1 res from cte order by res desc

为了比较你的int值，首先你需要把你的字符串分成rows中的各个int值。然后只有你可以在给定的条件下检查它们。
尽管in (1,2)在此查询中仍然是静态的。

错误您正在尝试比较int和varchar
这应该对你有用

declare @Class varchar(20) 
set @Class = '4,6,8,1'

select 
case
when value in (1, 2) 
then 1 
else 0 end as result 
from STRING_SPLIT ( @Class , ',' )

TRY：如果没有更多值可供比较，以下是即时解决方案
--如果有值

CASE WHEN ('1' IN (4,6,8) OR '2' IN (4,6,8)) 
THEN 1 
ELSE 0 END

--如果是变量

CASE WHEN ('1' IN (@Class) OR '2' IN (@Class)) 
THEN 1 
ELSE 0 
END

DECLARE @Class varchar(20)   
set @Class='4,6,8'  
DECLARE @intFlag INT  
DECLARE @temp INT  
SET @intFlag = 0  
WHILE (LEN(@Class)>0)  
BEGIN  
 if (CHARINDEX(',',@Class)=0)  
 begin  
 set @temp=@Class  
 set @Class=''  
 end  
 else 
 begin  
set @temp= SUBSTRING(@Class,1,CHARINDEX(',',@Class)-1)   
set @Class= SUBSTRING(@Class,CHARINDEX(',',@Class)+1,len(@Class)-CHARINDEX(',',@Class))
end   
set @intFlag= case when @temp in (1,2) then 1  else 0 end  
END  
select @intFlag