Export (0) Print
Expand All

+ (String Concatenation)

SQL Server 2000

Is 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
Is any valid expression in Microsoft® SQL Server™ 2000 Windows® CE Edition (SQL Server CE) 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.


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

SELECT FirstName + ' ' + LastName AS "Employee Listing" FROM Employees ORDER BY FirstName

© 2014 Microsoft