Re: Specifying row separators

[John Zandbergen]

OK, well....
I kept on searching and trying and since no other solutions came, I'll show you my solution:

set @a:='';
select count(@a:=concat(@a, theText)) from completetext;
select @a;

which produces a count of the records, then a newline and then the texts in a long stream of characters.
Now I can delete the first line from the output and voila: I've got the complete text without row separators.

Bye,
John