Tks for your adv Mark but i tried something quite the same without success .. below all options that i used so far

1)

Stuff

(

(

Select ',' + City As [text()]

From #tempCityState

Where State = t.State

For Xml Path('')

)

, 1, 1, ''

) As Cities,

------------

2)

Stuff

(

(

Select ',' + City

From #tempCityState

Where State = t.State

For Xml Path(''), Type

).value('.', 'varchar(max)')

,1,1,''

) As Cities

--------------------

3)

Stuff

(

(

Select char(10) + City As [text()]

From #tempCityState

Where State = t.State

For Xml Path('')

)

, 1, 1, ''

) As Cities,

------------------

4)

Stuff

(

(

Select Char(10) + City

From #tempCityState

Where State = t.State

For Xml Path(''), Type

).value('.', 'varchar(max)')

,1,1,''

) As Cities

Thanks anyway