dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
 

Tip: Using the STRING_AGG SQL Server 2017 Function

Learn how to perform grouped string concatenation.


advertisement

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

 

Visit the DevX Tip Bank

 



   
Thanks for your registration, follow us on our social networks to keep up-to-date