Kbase P18738: How to concatenate array fields together in SQL-92?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
GOAL:
How to concatenate array fields together in SQL-92?
FIX:
To concatenate array fields together and return the resulting value as a single column do the following:
SELECT PRO_ELEMENT(ArrayField,1,1) +
PRO_ELEMENT(ArrayField,2,2) +
PRO_ELEMENT(ArrayField,3,3) AS 'Contents'
FROM PUB.SomeTable