title: How to get custom separators in SQL Server query
body: <p>I have a table in SQL Server that looks like this</p>
  <pre><code>Value   First  Last   Email        Phone
  -----------------------------------------------------
  1       Smith CLEO some@yahoo.com 123456774
  </code></pre>
  <p>If this table was in Oracle and I wanted to get all the properties separated by different separators then I would write something like this</p>
  <pre><code>Select 
  Value ||','||
  First ||'!'||
  Last ||'?'||
  Email ||'~'||
  Phone
  from user_table;
  </code></pre>
  <p>I would get output like this</p>
  <pre><code>1,Smith!CLEO?some@yahoo.com~123456774
  </code></pre>
  <p>Notice all the separators are different. How can I write a similar select statement for SQL Server?</p>