Concatenate two Column with comma seperated

imran azam

10y1.1k

Please Help me to find the Query

I want to Concatenate Column1 and To column2 with comma seperated

Output like this... 9-10,5-5-6,90-100,100-200

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Imtiyaz Ansari10y ago
Accepted answer
Hi Imran

Try This ...
CREATE TABLE [dbo].[Test](
[Name] [varchar](50) NULL,
[Name1] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[Test] ([Name], [Name1]) VALUES (N'1', N'5')
GO
INSERT [dbo].[Test] ([Name], [Name1]) VALUES (N'2', N'10')
GO
INSERT [dbo].[Test] ([Name], [Name1]) VALUES (N'3', N'15')
GO
--//==============Select =========================
DECLARE @ConcatString VARCHAR(4000)
SELECT @ConcatString = COALESCE(@ConcatString + ', ', '') + Name +'-'+ Name1 FROM Test
SELECT @ConcatString AS Test
GO

--==========================================
+1
Imtiyaz Ansari10y ago
Welcome...........!!!
0
imran azam10y ago
Thank Imtiyaz bhai... i got my answer.
using your code and minor changes...

DECLARE @ConcatString VARCHAR(4000)
SELECT @ConcatString = COALESCE(@ConcatString + ', ', '') + Concat(Name,'-', Name1) FROM Test
SELECT @ConcatString AS Test
GO

Thanks a Lot.

0
imran azam10y ago
yes, i want like this but in comma seperated...
Output like this... 9-10,5-5-6,90-100,100-200
Because these number From and To are related with some Package id. So i want to update all data in another table column like 9-10,5-5-6,90-100,100-200
0
Guest User10y ago
You mean like this?

SELECT CONCAT([From], '-', [To]) FROM YourTable
+1