Concatenate Rows Into A String Variable

DECLARE @Course varchar(Max)

SELECT @Course = COALESCE(@Course + ' , ', '') + Course_Name
FROM Course
where Course_Name like 'B%'

print @Course