Talk In Code

If you want to concatenate the output of three different columns in MS SQL just use the + symbol.

SELECT table.column1 + ' ' + table.column2 + ' ' + table.column3 output FROM table

The resulting column will be the values of the three columns under the name of output