• Try something like

    declare @Remarks varchar(1000)

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

    select @Remarks

    Regards

    Ziyad_s@maktoob.com