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

>
> Hi,
>
> what I need is to send a list of integer values as a single input
> parameter to a stored procedure (Firebird 1.5). The number of values
> may vary.
> I can't see how to send an array of integers directly so I think of
> sending them as a delimited string, like '120,5,874004,300'
> Then in the stored procedure I want to split the string and convert
> substrings to integers.
> The problem is I have no idea how to split a string.
> On some site I read FB has POSITION() and SUBSTRING() functions which
> seems sufficient, but any attempt to use POSITION in a stored procedure
> results in errors.
>
> Any hint how to split a string?
>
> Thanks,
> Peter
>

Hi Peter,
May this will help :
http://www.volny.cz/iprenosil/interbase/ip_ib_code_string.htm