2.1.1.7 E021-07, Character concatenation

  • Article

V0007:

The specification states the following:

 Subclause 5.2, "<token> and <separator>":
  
 <concatenation operator> ::=
 ||
  
 Subclause 6.29, "<string value expression>":
  
 <concatenation> ::=
 <character value expression> <concatenation operator> <character factor>

Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:

Transact-SQL does not support this feature. See the + (Add) operator [MSDN-Add] for equivalent functionality to the concatenation operator (||) operator in [ISO/IEC9075-2:2011].