Seems fine to me, assuming you are declaring and initializing @extra:declare @extra nvarchar(max);set @extra = '';select @extra = @extra + cast(shipdate as nvarchar(255)) + '<br>' from orders;select @extra;
You can also try the following (which has the added benefit that it will let you order the dates if you need to so they appear in a predictable order in the final stringselect CAST( (select cast(shipdate as nvarchar(255)) + '<br>' from orders for xml path('')) as xml).value('.','nvarchar(max)')