Thanks your code works . But my notes field is type ntext when i run the code i get

The data types ntext and char are incompatible in the add operator.

if OBJECT_ID('tempdb..#Something') is not null

drop table #Something

create table #Something

(

RowPointer char(7),

Notes NTEXT

)

insert #Something

select 'Row0001', 'TestNotes1' union all

select 'Row0002', 'TestNotes2' union all

select 'Row0003', 'TestNotes3'

select top 1 RowPointer, STUFF((select Notes + char(10)

from #Something

order by RowPointer

for XML PATH('')), 1, 0, '')

from #Something

The data types ntext and char are incompatible in the add operator.