Hi jon,

Refer below link to split value using comma.

Insert Comma Separated (Delimited) values in a Table in SQL Server

Refer below query.

SQL

DECLARE @Lines AS NVARCHAR(MAX)
SET @Lines = 'USA,UK'
SELECT * FROM Customers
WHERE Country IN ( SELECT Item FROM SplitString(@Lines,','))