t-sql string concatenation
Posted
by stackoverflowuser
on Stack Overflow
See other posts from Stack Overflow
or by stackoverflowuser
Published on 2010-03-19T22:24:56Z
Indexed on
2010/03/19
22:31 UTC
Read the original article
Hit count: 520
i have a table that has following column
Type
--------
type 1
type 2
type 3
How can i convert the above to a string like ('type 1', 'type 2', 'type 3')
I want to use the output in my t-sql query with IN clause. Something like select * from TableA where SomeColumn IN ('Type 1','Type 2', Type 3')
I used to following to come up with output (type 1, type 2, type 3)
select '(' + STUFF((select ', ' + Type from TableA for xml path ('')),1,2,'') + ')'
But dont know how to insert the single quotes.
© Stack Overflow or respective owner
