title: How to concatenate strings of multiple columns from table in SQL Server using dplyr?
body: <p>As title, I would like to concatenate a few columns from a table in SQL Server, I tried to use the <code>paste</code> function as below but give the following error:</p>
  
  <pre><code>&gt; tbl(channel,'##iris') %&gt;% 
  +   mutate(string=paste(Species,'-',
  +                       Sepal.Length,'-',
  +                       Sepal.Width,'-',
  +                       Petal.Length,'-',
  +                       Petal.Width,sep=''))
  Error: PASTE() is not available in this SQL variant
  </code></pre>