How to convert columns to a single Row in Sql Server?

declare @Name VARCHAR(8000)
select @Name = Coalesce(@Name,'') + pat_name + ',' from pat_info where pat_name like 'P%'
select @Name[Name]