To get an array out:
1) One element
Select Job_title[2] from employee into where Last_name = :lname
2) 3 elements
Select Job_title[2:4] from employee where Last_name = :lname
This will select Job_title[2], [3] and [4]
To RobPouwelse:
Interbase can store multiple data in the same column, but they must be of the same data type.
Take for example a table where one person can have multiple phone numbers. Declaring the Pnone Column as :
create table blabla
(Phones char(20)[3]);
Will make phones a 3 element array
Regards
S. van Els
SAvanEls@cq-link.sr