Concatenate two Column with comma seperated

Question

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

Imtiyaz Ansari · 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 --==========================================

Guest User · Answer

You mean like this? SELECT CONCAT([From], '-', [To]) FROM YourTable

Imtiyaz Ansari · Answer

Welcome...........!!!

imran azam · Answer

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.

imran azam · Answer

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

Concatenate two Column with comma seperated

Answers (5)