Can some one tell me how to use the IN keyword to select rows from a table whose one column's value is already defined in an array? Here is my situation: provided a 'array' let say 'value1,value2,value3' I would like to do the following:
declare @values varchar(max)
set @values = 'value1,value2,value3'
select * from table1 where colum1 in @values