title: sql query to get data having special characters from a column
body: <p>I want to get data from this column having all kind of special charaters.</p>
  
  <p>The special characters are as below:</p>
  
  <pre><code>&amp;   *   ,   .   :   ;   `   ~   ¿   Ä   Å   Ç   É   Ñ   Ö   Ü   ß   à   á    
  â   ä   å   ç   è   é   ê   ë   ì   í   î   ï   ñ   ò   ó   ô   ö   ù   ú    
  û   ü   ÿ   ƒ   α   
  </code></pre>
  
  <p>I am running the below query, but no result:</p>
  
  <pre><code>select A.Street  
  from ADRC a
  where A.Street like not LIKE '%[^A-Za-z0-9, ]%'
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/6zD5n.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/6zD5n.png" alt="enter image description here"></a></p>
  
  <p>the above result is fetched from </p>
  
  <pre><code>select A.Street  
  from ADRC a
  </code></pre>
  
  <p>when I am running the like clause i m not getting results.</p>