title: SQL Server : Nvarchar to Varchar
body: <p>I have a table with two columns, one is of type <code>Varchar</code> and the other in <code>NVarchar</code>.</p>
  
  <p>I want to update all the rows so VarcharField = NVarcharField.</p>
  
  <p>It won't let me because some of the rows contain chars that are not allowed in <code>varchar</code> column with the current code page.</p>
  
  <p>How can I find these rows?</p>
  
  <p>Is it possible to remove any char that doesn't fit the specific code page I'm using?</p>
  
  <p>SQL Server 2012.</p>