title: Sql query combine 2 or more columns into one cell
body: <p>my query brings 3 fields
  For example, if I have the following code:</p>
  
  <hr>
  
  <pre><code>select C.ContactId,C.CityId,C.ZipCode
  from Contacts C
  Where c.ContactId=256
  </code></pre>
  
  <hr>
  
  <p>all fields are int type</p>
  
  <p>but I want all in one cell
  I thought it might be like the statement below;but it didnt work</p>
  
  <hr>
  
  <pre><code>select Convert(varchar(50),C.ContactId+','C.CityId,C.ZipCode)
  From Contacts C
  </code></pre>