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

Arguments

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

Result Types

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

Example

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