MS SSQL tutorial showing various ways to concatenate results.

This is a Microsoft SQL tutorial demonstrating different ways of concatentating results. This tutorial includes use of the CONCAT function and using the + (plus) sign. It also shows how to use the CAST function to deal with the error: The data types varchar and bit are incompatible in the add operator.
Complimentary videos:
Concatenate with FOR XML: • MS SQL tutorial on FOR...