Hi Casper
Thanks so much for this, it worked like a dream.
Here is my final WORKING code.....
select "cl-analysis-code-element"[1] as cl1,
"cl-analysis-code-element"[3] as cl3,
"cl-analysis-code-element"[4] as cl4
from ih.pub."rm-job"
where "job-no" > 'G000000'
Excellent result, you...