therealdreamer81
asked on
Concatenate string using Group By
How do I concatanate strings with MSSQL?
e.g. table values:
cGroup cText
A L
A M
B V
query:
select cGroup, concat(cText) as cTextConcat
from myTable
group by cGroup
Result set:
cGroup cTextConcat
A LM
B V
e.g. table values:
cGroup cText
A L
A M
B V
query:
select cGroup, concat(cText) as cTextConcat
from myTable
group by cGroup
Result set:
cGroup cTextConcat
A LM
B V
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
AngelllI - v.v.v. cool solution....
Forced accept.
Computer101
Community Support Moderator
Computer101
Community Support Moderator