Subject possible to split a delimited string?
Author peter_nn0

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?