This question is really about sql server syntax.


I am trying to send an array to a sql stored procedure
from a asp page (javascript).

For example

the array has 3 document numbers in one string
"doc123, doc456, doc789"

goes to sql stored procedure called getdocs(@docnum)

how does sql convert the string to use in the sql
select statement "select a.* from maintable where a.docnum = @docnum)