How to Get Columns Data In Single Row with cumma (,) Separated in Sql server 2005

 SELECT STUFF(
 (
     SELECT  ', ' + VALUE      FROM
     (
       SELECT VALUE  FROM dbo.Split('DPTHD,UH,IH,FH,LH,DH,IS', ',')
       
     ) AS T FOR XML PATH('')
 )
 ,1,1,'') AS [VALUE]

=======================================================================

use Split Function

CREATE FUNCTION dbo.Split
(
@RowData nvarchar(2000),
@SplitOn nvarchar(5)
)
RETURNS @RtnValue table
(
Id int identity(1,1),
Data nvarchar(100)
)
AS
BEGIN
Declare @Cnt int
Set @Cnt = 1

While (Charindex(@SplitOn,@RowData)>0)
Begin
Insert Into @RtnValue (data)
Select
Data = ltrim(rtrim(Substring(@RowData,1,Charindex(@SplitOn,@RowData)-1)))

Set @RowData = Substring(@RowData,Charindex(@SplitOn,@RowData)+1,len(@RowData))
Set @Cnt = @Cnt + 1
End

Insert Into @RtnValue (data)
Select Data = ltrim(rtrim(@RowData))

Return
END