Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Concatenation Operators

Concatenation Operators

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

The concatenation operator is the plus sign (+). You can combine, or concatenate, two or more character strings into a single character string. You can also concatenate binary strings.

The following code is an example of concatenation operator that combines the product name with the product's unique name:

WITH MEMBER Measures.ProductName AS 
   Product.Product.CurrentMember.Name + " (" + Product.Product.CurrentMember.UniqueName + ")"
   {Measures.ProductName} ON COLUMNS,
   Product.Product.Members ON ROWS
FROM [Adventure Works]

When the strings used in a concatenation both have the same collation, the resulting concatenated string has the same collation as the inputs. When the strings used in a concatenation have different collations, the rules of collation precedence determine the collation of the resulting concatenated string. For more information, see Languages and Collations (Analysis Services).

Community Additions

© 2015 Microsoft