Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

+ (String Concatenation) (SQL Server Compact)

The plus (+) can be used as an operator in a string expression that concatenates two or more character or binary strings, columns, or a combination of strings and column names into one expression.

expression + expression


A valid expression in Microsoft SQL Server Compact 3.5 of any of the data types in the character and binary data type categories, except the image and ntext data types. Both expressions must be of the same data type, or one expression must be able to be implicitly converted to the data type of the other expression.

Returns the data type of the argument with the highest precedence.

The following example uses the + operator to get an alphabetical listing of all employees in the Employees table.

SELECT FirstName + ' ' + LastName AS "Employee Listing" FROM Employees ORDER BY FirstName
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft