Output long strings

-- declare a variable to hold our big string
declare @bigString varchar(max)

-- Add code to store the big string into our @bigString variable
select @bigString = sResponse
from S1_LogAQ a
where a.lRowID = 5288

-- get the total length of the big string
declare @totalLen int
set @totalLen = len(@bigString)

declare @size int
	, @start int
	, @sub varchar(max)

-- set the start position
set @start = 1
-- set the number of characters to print on each line
set @size = 5000

-- keep going while the start position is within the size of the big string
while (@start <= @totalLen)
begin
	-- get the substring to print
	set @sub = substring(@bigString, @start, @size)
	-- print it
	print @sub

	-- set the start position for the next time around
	set @start += len(@sub)
end