title: MS SQL Select Where ntext-Column contains specific hex String
body: <p>I have a problem in a select on mssql</p>
  
  <p>in my table there is a column with datatype ntext and i'm searching for an specific character.
  when i read the value and convert it to hex ill get something like that</p>
  
  <pre><code>SELECT convert(varbinary(max),convert(nvarchar(max),COLUMN_Value))  FROM db.TABLE WHERE PK = 1234
  
  0x3C005000200063006C006100730073003D004D0073006F004E006F0072006D0061006C0020007300740...
  </code></pre>
  
  <p>In the hex value there is for example 3C00, when I now rewrite my select and search for this value no row is matching :/</p>
  
  <pre><code>SELECT * FROM db.TABLE WHERE convert(varbinary(max),convert(nvarchar(max),COLUMN_Value)) LIKE '%3C00%'
  </code></pre>
  
  <p>Does anybody know whats the problem here?</p>