The STRING_AGG SQL Server 2017 function performs grouped string concatenation.
STRING_AGG
Here is an example:
SELECT STRING_AGG(value, ' ') AS Result FROM (VALUES('Hannes'),('du'),('Preez')) AS I(value);
This returns:
Hannes du Preez in the Result column