SQL中判断一串字符中是否有特定的字符

DECLARE @s VARCHAR(100),@sql VARCHAR(1000)
SET @s='1,2,3,4,5,6,7,8,9,10'

一：
SET @sql='select col='''+ replace(@s,',',''' union all select ''')+''''
PRINT @sql
EXEC (@sql)
二：
SELECT B.id
FROM 
( SELECT [value] = CONVERT(XML , '<v>' + REPLACE(@s , ',' , '</v><v>') + '</v>') ) A
OUTER APPLY ( SELECT  id = N.v.value('.' , 'varchar(100)') FROM A.[value].nodes('/v') N ( v ) ) B

 

转载于:https://www.cnblogs.com/harryhan1983/p/4450785.html