title: How to concatenate columns properly using T-SQL?
body: <p>I have a address in more than one column in a table. </p>
  
  <pre><code>SELECT FirstName, LastName, StreetAddress, City, Country, PostalCode 
  FROM Client
  </code></pre>
  
  <p>I am trying to concatenate address related columns into one filed using Comma (,) as a separator but if any of the column "eg. City" is null or empty, comma should not be there.</p>
  
  <p>How to use ternary operator in TSQL like one has in c#?
  Or suggest me the best practice?</p>
  
  <p>Thanks</p>