you've different options1. use a string parsing UDF and get the array returned as a table of values and use it in join to do filteringso in your caseSELECT...FROM......your rest of the queryINNER JOIN dbo.ParseValues('first,second,third',',')fON f.Val = Yourtable.Field
ParseValues can be found in below linkhttp://visakhm.blogspot.in/2010/02/parsing-delimited-string.html2. Use string based comparison likeDECLARE @FilterList varchar(8000)SET @FiletrList = 'First,Second,Third'SELECT......rest of queryWHERE ',' + @FilterList + ',' LIKE '%,' + YourTablefield + ',%'
there are few other methods also like XML method which is discussed in below linkhttp://vyaskn.tripod.com/passing_arrays_to_stored_procedures.htm------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/