Kbase P19925: How to separate elements of an Array with a blank using SQL-
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/24/2003 |
|
Status: Unverified
GOAL:
How to separate the three elements of an Array with a blank using SQL-92?
FACT(s) (Environment):
Progress 9.x
FIX:
Use code similar to:
SELECT
RPAD(PRO_ELEMENT(ArrayField,1,1), LENGTH(PRO_ELEMENT(ArrayField,1,1)) + 1) +
RPAD(PRO_ELEMENT(ArrayField,2,2) , LENGTH(PRO_ELEMENT(ArrayField,2,2))+1)+
PRO_ELEMENT(ArrayField,3,3)
FROM PUB.Customer;