Select multiple column into a single column

If you use SQL Sever 2012, you can use the new CONCAT function:

select concat(col1,col2,col3)  as newCol From SS2012DBTable