title: Is there a way to detect unicode chars in a nvarchar column
body: <p>The input column was not implemented well enough to restrict the email chars to roman... therefore French and Spanish chars with accents have made it into the database, but are being rejected by the remote mail servers. Is there a simple SQL test?</p>
  
  <p>I tried</p>
  
  <pre><code>where email &lt;&gt; try_cast(try_cast(email as varchar) as nvarchar)
  </code></pre>
  
  <p>While it seems to have worked to an extent it also seems a little aggressive in that it found more matches then non.</p>