combine 3 or more columns to one in sql-server
<p>I have tried combining columns using 
select (column1 + ',' + column2 + ',' + column3) as column4 from table. But i didn't really get the result for three columns. It had worked for two columns. when i try to add one more its not retrieving any information from the table.Please help me in this.</p>