Posted by Rakesh Makhijani on 09/09/05 12:36

Sorry, I forgot to complete my code.

In SP u can use

declare @Sql varchar(8000),
@AllValues varchar(1000)

SELECT @Sql='select * from table where column IN (' + @AllValues + ') '

exec (@Sql)


Rakesh

*** Sent via Developersdex http://www.developersdex.com ***

[Back to original message]