I am pulling my hair out trying to produce a efficient solution to a problem
I have.

I need to generate a SQL 'IN' statement on the fly in a stored procedure,
I wanted to pass an array into the procedure to generate the IN statement
but I don't believe this can be done. So instead I need to pass in some deliminated
text, which cannot be comma deliminated! So please could some one suggest
how I should replace my deliminator in SQL with a new deliminator so I can
assign this to a new variable to be held in the IN statement!

I would appreciate any suggestions anybody has!