Is there an operator in the latest standard SQL:2011 (or earlier) that will handle group concatenation the likes of which we currently have to resort to these tricks for?
Here's a recent question on this site for which various answers were given to different RDBMS.
Since this is a small question for the heavyweight site DBA.SE, please find two sub-parts to the question:
- Is there a publicly accessible draft of SQL:2011?
- Which part of the SQL standard (any revision) states that CONCAT NULL should YIELD NULL? I can't seem to track it down in the volume of text in the standard.