ASP.Net parameters

[Big E]

I have a listbox on a ASP.Net form. The listbox contains all the communities
that belong to this record. I've been trying to create a stored procedure
that will look up values in a table bases on the contents of the listbox.
The problem is that I only have one parameter called @communities but there
are several communities. The parameter only does one community.
My statement should look like this SELECT * From Table where Communities =
@Communities.
But only one community goes into the sp.

Thanks.

Big E

 

[Bobby Ryzhy]

Try this -
SELECT * From Table where Communities in (@Communities)

@Communities will now be a comma delimited string

Bobby Ryzhy
bobby@ name of domain below
http://www.weekendtech.net