help with concatente

hallow

i wont to concatete all the value that i get in wa_mail_addr into field like char255

how i do that?

regards

SELECT value

FROM yhr_parameters " Adress Table

INTO wa_mail_addr

WHERE title = 'YHR'

AND subtitle = 'MU'

AND name = 'SEND_MAIL'.

endselect.