Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion AI Tools Integration
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

forum

Home Forums How to concatenate text from multiple rows into a single text string in SQL Server – MindStick
Ask Question

1 Answers

Ashutosh Patel
Ashutosh Patel 15 Jul 2024
Report Abuse

You can contact multiple row values into a single text string value by using the SQL built-in function STRING_AGG(). 

Note- STRING_AGG() function supported in SQL Server version 2017 and later

Syntax- 

SELECT STRING_AGG(column_name, ', ') as ConcatedText FROM table_name

The STRING_AGG() function requires 2 argument(s), the first one is the column name and the second one is a separater between values as you see in the above syntax.

Example-

suppose we have a Employees table. 

CREATE TABLE Employees
(
	EmpId INT PRIMARY KEY NOT NULL,
	EmpName NVARCHAR(50), 
	Gender NVARCHAR(20),
	Salary DECIMAL(10, 2)
)

Let's insert some values into above table,

INSERT INTO Employees
VALUES('Priya Shukla', 'Female', 70788),
('Ashutosh Verma', 'Male', 50066),
('Rani Sharma', 'Female', 57722),
('Amit Tiwari', 'Male', 81391),
('Ashu Patel', 'Male', 57659),
('Samiksha Mishra', 'Female', 15000),
('Akanksha Singh', 'Female', 15000);

As you can see in the below picture,

Ashutosh Patel

Example-

Now, use STRING_AGG() to concat multiple row values into a single string,

SELECT STRING_AGG(EmpName, ', ') as ConcatedText FROM Employees

-- output: Priya Shukla, Ashutosh Verma, Rani Sharma, Amit Tiwari, Ashu Patel, Samiksha Mishra, Akanksha Singh

Also, Read: How to use searching and filtering data in an SQL server?

advertising
Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md