Have now worked this out. The solution was to forget EXPLICIT altogether and go with XML PATH and nested XML SELECT statements.

Both excellent responses. Thank you. I tried the "mailto:" approach and it works very nicely but I probably can't use it as a solution because we actually use...