How can I pass parameters from a multiselect listbox to a SQL Stored Procedure?

multiselect listbox passes value as a comma separated list, for example

for e.g.
<select name="car" size="5" multiple id="car">
<option value="">--SELECT--</option>
<option value="1">Honda</option>
<option value="2">Toyota</option>
<option value="3">Nissan</option>
<option value="3">Mercedez</option>
</select>

If you select first two cars the value should be 1, 2

You have not provided any detail, whether you want to perform insert,update or delete in your stored procedure I am pointing to a link from Narayana Vyas. Hope this will help.

http://vyaskn.tripod.com/passing_arr...procedures.htm

What I am trying to do is just Select States from the list and also have a text box so a user can enter a last name the results will return certain fields from the table.

something like this..
CREATE PROC ProcGetResult
@StateList varchar(500),
@LastName varchar(50)
AS
BEGIN
     SELECT field1, field2, field3
     FROM MyTable
     WHERE State IN (@StateList) And LastName = @LastName
END
GO