title: TSQL: Values of all field in a row into one string
body: <p>i need to put all, not null, values of single row into one string, like</p>
  
  <p>table:</p>
  
  <pre><code>CustomerName  Address Zip
  Alex          Moscow  1234
  </code></pre>
  
  <p>to result:</p>
  
  <pre><code>CustomerName: Alex
  Address: Moscow
  Zip: 1234
  </code></pre>
  
  <p>Important note - i don't know field names/types, so it should go through all fields and all not null values add to list.</p>
  
  <p>Looks like it can do this using xquery, but can't find right syntax. 
  Any hints?</p>
  
  <p>Thanks!</p>