Dear All

I m facing a problem with Sql stored procedure.
I create a stored with @Key parameter and write a query in it Like

Select * From Table where key in ( @key)

It works fine when i Execute Sp like this

Exec Sp_Test '12345'

But when i pass a list of values from Vb to that parameter like

'1245','475','11445' in this case this gives me no result.

So pls advice me how can i pass this list into my SP parmeter form VB.

Regards
Kapil Kumar

Ahhhhh, the old "How to use an IN clause in a stored proc" puzzle.

Well, there are several ways to do this.

One way is to create a temporary table, populate the temporary table by parsing the values passed in the @Key parameter, and then use that temporary table in as select statement nested within your outer select statement.

I did a quick google and here is a link to an example:
http://www.codeproject.com/database/...&select=727155

Woody Z http://www.learntoprogramnow.com