Hi,

I have an SQL problem where I need to take a comma delimited string and
convert that string to recordset returned by a stored procedure.

for example if i have a comma-delimited string value '1, joe bob, 23.1,
@#$#@,rubberduckies,43'

i want to manipulate the string so that the stored procedure returns a
table
1
joe bob
23.1
@#$#@
rubberduckies
43

I would like to avoid making a table in the stored procedure. can anyone
help me with this?

regards

Z T