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
Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: