title: Selecting special characters only from table with Japanese name
body: <p>I'm using SQL Server on a table of Japanese names. I'm trying to return any field that contains a special character(eg, - / $ .) but it's also returning any Japanese character. </p>
  
  <pre><code>select names from nameTable
  where 
  (names &lt;&gt; '' and names not like N'%[a-z0-9]%')
  </code></pre>
  
  <p>I'm using various versions of the above to get my results and it does technical work.</p>
  
  <p>Just wondering if anyone has any advice on how to exclude the Japanese characters from my results.</p>
  
  <p>If more information is needed please ask.</p>