Subject Re: possible to split a delimited string?
Author Doru Ilasi
--- In, "peter_nn0" <peter_nn0@...>
> 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 :