title: SQL server - how to find Hexadecimal character in a table
body: <p>How to search hexadecimal characters from a SQL Server table? Actually I tried like below but it is searching all zeroes in the field.</p>
  
  <pre><code>select Email,* 
  from address 
  where CHARINDEX(convert(varchar, Ascii(0x00)), Email) &gt; 0
  </code></pre>
  
  <p>Thanks</p>