send multiple values to SP

[shank]

I have a stored procedure that requires one variable to be filled: WHERE
ItemNo = @ItemNo
Instead of sending 1 value, I'd like to send a bunch of values.
I don't mind changing the SP if I new how to approach this.
The user would select any number of ItemNo's from a form and submit.
Assume ItemNo's like: B1, B2, B3, etc...
The end result would be something like ...
WHERE ItemNo = B1 or ItemNo = B5 or ItemNo = B10 ...etc....

I want to build a recordset based on the user's selections.
How?

thanks!

 

[Bob Barrows [MVP]]

I have a stored procedure that requires one variable to be filled:
WHERE ItemNo = @ItemNo
Instead of sending 1 value, I'd like to send a bunch of values.
I don't mind changing the SP if I new how to approach this.
The user would select any number of ItemNo's from a form and submit.
Assume ItemNo's like: B1, B2, B3, etc...
The end result would be something like ...
WHERE ItemNo = B1 or ItemNo = B5 or ItemNo = B10 ...etc....

This article details many alternatives:
http://www.sommarskog.se/arrays-in-sql.html

Bob Barrows