Concatenation Operators and LOB Locators

The + and || Transact-SQL operators accept LOB locators as expressions for a concatenation operation. The result of a concatenation operation involving one or more locators is a LOB locator with the same datatype as that referenced by the input locator.

For example, assume that @v and @w are text locator variables. These are valid concatenation operations:

select @v + @w
select @v || "abdcef"
select "xyz" + @w