--- In firebird-support@yahoogroups.com, "ztminhas" <ztminhas@...> wrote:

>
> 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?

You should avoid mixing any DDL in the same transaction as DML.

Technically speaking, stored procedure don't return tables. They
return recordsets, resultsets, datasets or whatever else you want to
call them.

This will be of interest:
http://www.fbtalk.net/ViewTopic.aspx?id=154

Adam