Use string type comma separated in IN clause in sql

 declare @ProductIds nvarchar(50)='18,19'

SELECT * FROM products Where (',' + @ProductIds +',' LIKE '%,' + CONVERT(VARCHAR, ProductId) + ',%')