Hi,

Send them as a string of comma seperated values instead of an array. Then, in your sp, do this:

Code:

declare @sql varchar(1000)
Set @sql = 'Select * From Products Where Prod_Code IN (' + @values + ')'
exec(@sql)



Where @values is your parameter.

__________________
S.Balasubramanian
Nothing is impossible