title: SQL Server error "Implicit conversion of because the collation of the value is unresolved due to a collation conflict."
body: <p>I getting this error while developing stored procedure</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>statement is like this</p>
  
  <pre><code>Select City COLLATE DATABASE_DEFAULT AS Place, State, Country FROM DEPT1
  UNION ALL
  Select '' AS Place, 'Arizona' As State, Country FROM DEPT2
  </code></pre>
  
  <p>but If If do this it also give same error</p>
  
  <pre><code> Select City COLLATE DATABASE_DEFAULT AS Place, State, Country FROM DEPT1
   UNION ALL
   Select '' COLLATE DATABASE_DEFAULT AS Place, 'Arizona' As State, Country FROM DEPT2
  </code></pre>
  
  <p>Actually this code is written by some one else and am just editing the code, do not know why he added  COLLATE DATABASE_DEFAULT but If I remove it also gives the same 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>