Using the STRING_AGG SQL Server 2017 Function

The STRING_AGG SQL Server 2017 function performs grouped string concatenation.

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