tale103108
New Member
Can anyone provide an example on how to filter on a array column in SQL?
for example:
select "employee"
from "employee"
where "age[2]" > 40;
"age" would be an array column in the table "employee" and I wish to look at the third element.
Of course this SQL does not work but you get the idea. How does one doe this in Progress? I see that the array elements are separated by a ";" but I can not parse them.
Please advise....with an example SQL.
Cheers!
for example:
select "employee"
from "employee"
where "age[2]" > 40;
"age" would be an array column in the table "employee" and I wish to look at the third element.
Of course this SQL does not work but you get the idea. How does one doe this in Progress? I see that the array elements are separated by a ";" but I can not parse them.
Please advise....with an example SQL.
Cheers!