title: (Select FirstName + ' ' + LastName from Members gives error Implicit conversion of varchar value to varchar cannot be performed
body: <pre><code>Select FirstName + ' ' + LastName from Members 
  </code></pre>
  
  <p>Gives error:</p>
  
  <blockquote>
    <p>Implicit conversion of varchar value to varchar cannot be performed because the collation of the value is unresolved due to a collation conflict.</p>
  </blockquote>
  
  <p>But it works fine when I take <code>FirstName</code> and <code>LastName</code> in separate columns like </p>
  
  <pre><code>Select FirstName, LastName From Members
  </code></pre>
  
  <p>I want to pick First and Last name in one column</p>