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 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