declare @string as varchar(60)

SELECT @string = ',stringval1,stringval2,stringval3,'

--you must have quotes at the beginning and the end of the string

SELECT *

FROM dbo.Table

WHERE CHARINDEX(',' + columnA + ',', @string, 0) >...