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:

  1. Is there a publicly accessible draft of SQL:2011?
  2. 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.

1 Answer 1


The wiscorp.com page SQL Standards has several older revisions and drafts of SQL:20nn (zip):

The 7IWD2-02-Foundation-2011-12.pdf, with a date of 2011-12-21 has at page 289:

If at least one of S1 and S2 is the null value, then the result of the <concatenation> is the null value.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.