Concatenation Operations
Visual Studio 2010
Concatenation refers to the operation of appending one sequence to another.
The following illustration depicts a concatenation operation on two sequences of characters.

The standard query operator methods that perform concatenation are listed in the following section.