dcsimg
LinkedIn
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL
Expertise: Beginner
Jan 15, 2020

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
Hannes du Preez
 
Close Icon
Thanks for your registration, follow us on our social networks to keep up-to-date