I have a string ("word word bob jack") such that I want to pass to the
store proc as a single entity,
split it in the store proc, and do a specific action for each word. Any
advice on how to do this? There is more going on that just that single
word so multiple calls isn't practical and they string will have N+1
elements so setting up a number of parameters is impractical (since the
word count may be as many as 1000).

Like a foreach statement?

> I have a string ("word word bob jack") such that I want to pass to the
> store proc as a single entity,
> split it in the store proc, and do a specific action for each word.
> Any
> advice on how to do this? There is more going on that just that
single
> word so multiple calls isn't practical and they string will have N+1
> elements so setting up a number of parameters is impractical (since
the
> word count may be as many as 1000).
>

I was able to create a loop based on the instr function and while.