[最佳答案] Split the input string and use IN clause to split the CSV to rows use this. SELECT Ltrim(Rtrim(( Split.a.value('.', 'VARCHAR(100)') ))) FROM (SELECT Cast ('<M>' + Replace('user1@domain.com,user2@domain.com', ',', '</M><M>') + '</M>' AS XML) AS Data) AS A CROSS APPLY Data.nodes ('/M') AS Split(a) Now use the above query in where clause. SELECT f_emailaddress FROM tb_users WHERE f_emailaddress IN(SELECT Ltrim(Rtrim(( Split.a.value('.', 'VARCHAR(100)') ))) FROM (SELECT Cast