[url]http://www.aspfaq.com/2248[/url]
[url]http://www.algonet.se/~sommar/arrays-in-sql.html[/url]
[url]http://www.algonet.se/~sommar/dynamic_sql.html[/url]


"Doug Eller" <delleradamcorp.com> wrote in message
news:OVLDj29PDHA.2476TK2MSFTNGP10.phx.gbl...
> I feel like an idiot, but some time ago, I asked the following question
and
> got a great tip from someone. Since then, my database crashed and I lost
all
> the work I did based on the tip. I hope whoever it was that helped me is
> still out there.
>
> Here's the question I posted a couple of months ago:
>
> ***************************************
> I know you can do this with implicit SQL:
>
> Select * From Whatever Where HowMuchEver IN (1','2','3','4')
>
> But can you create a stored procedure that will accept that array(
> (1','2','3','4') ) as an input value? If so......how?
> ***************************************
>
> The answer involved a user defined function.......HELP!!!
>
> Thanks,
> doug
>
>