Thanks guys, tried both those ideas however Jack, the limit is massive and checking len(@Summary) at the end of the code (not posted) shows my lengths to be tiny..

B, I tried that solution.. in the DB, for testing, 5 rows match the record, all with the "Details" fields set to "abcdefghijklmnopqrstuvwxyZabcdefghijklmnopqrstuvwxyZabcdefghijklmnopqrstuvwxyZ"

this is the output I get from your implementation...

, user Note - Paul user, 28/03/2007

abcdefghijklmnopqrstuvwxyZabcdefghijklmnopqrstuvwxyZabcdefghijklmnopqrstuvwxyZ

Only one row! This is the same as what I found when I tried to concatenate using the select query itself:

SELECT @Summary = @Summary + @KeyValue + ' Note - ' + @UserTitle + ', ' + @Date + CHAR(13) etc..