Concat string columns – SAP HANA: do you need to concat string columns in SAP HANA?

Try something like this:

create procedure concat_me (out itens nvarchar(200))

as begin

declare cursor C for SELECT OITM.”ItemName” from OITM;

itens := ”;

for R as C do

itens := :itens || R.”ItemName” || char(13) || ”;

end for;

select :itens as “Itens” from dummy;


then you can use this procedure to take the result of the concat.

If it does not work or you need help, write me!

New NetWeaver Information at

Very Helpfull



User Rating: Be the first one !