Try something like

declare @Remarks varchar(1000)

select @Remarks =IsNull(@Remarks,'') + Remarks from .. where ...

select @Remarks

Regards

Ziyad_s@maktoob.com