How do I use arrays in the FireBird SQL? I need to write a
Stored Procedure that can accept a string input and parse it to
separate out various substrings, based on a separator. I intend
to put the parsing logic into a UDF and call the UDF from the
SP. However I would need to use a string array in the SP to
hold the parsed output.

I also went through the SQL Language and Function reference
document I had downloaded for IB6, but it doesn't provide enough
information on the use of arrays.

Thanks in advance for any tips and suggestions,

Anand

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com