How can I use GROUP_CONCAT in ms sql

How can I use a GROUP_CONCAT function in ms sql. is there any alternative to this? I have a table likethis


Name---------------------------Favorite Color ID
Jim------------------------------3
Bob-----------------------------3
Bob-----------------------------12
Norman-------------------------2
Norman-------------------------1

i need to do an inner join on the tables to get each favorite color name for each Person

I need the result to print like this

Name---------------------------Favorite(s)
Jim------------------------------Red
Bob-----------------------------Red,Yellow
Norman------------------------Black, White

Is it possible to do this without stored Procedures
Start Free Trial