how to concatenate Sql query result With some strings?

Question

Have to concatenate sql query result With some strings. I am getting sql query result like this

+--------------------+
|    Some Value      |
+--------------------+
|abc,xyz,amar,akbar  |
+--------------------+
|   hjk,fed,fas      |
|                    |
+--------------------+

I want to concatenate ' with each row result like this and I am using Sql server 2012.

+--------------------------+
|    Some Value            |
+--------------------------+
|'abc','xyz','amar','akbar'|
+--------------------------+
|   'hjk','fed','fas'      |
|                          |
+--------------------------+

Please help me..

PLEASE LOOK HERE 1keydata.com/sql/sql-concatenate.html

Neeraj Prasad Sharma
– Neeraj Prasad Sharma

2015-08-25 12:01:48 +00:00
Commented Aug 25, 2015 at 12:01 — Neeraj Prasad Sharma
– Neeraj Prasad Sharma, Commented Aug 25, 2015 at 12:01

Felix Pamittan · Accepted Answer · 2015-08-25 12:06:47Z

1

You can add a ' on the start and end of your string. Then REPLACE , with ',':

SQL Fiddle

SELECT '''' + REPLACE(some_value, ',', ''',''') + '''' FROM tbl

edited Aug 25, 2015 at 12:06

answered Aug 25, 2015 at 12:00

Felix Pamittan

31.9k7 gold badges43 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

GPAdiga Over a year ago

thanks ...Felix Pamittan

Collectives™ on Stack Overflow

how to concatenate Sql query result With some strings?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related