title: SQL Server : removing 0x00 characters from a string
body: <p>I am comparing 2 strings, where one of them is assigned by me, and the second one is taken from a table. </p>
  
  <p>The one from the table, after I converted it to hex, shows '00' signs like in example <code>1400210068008100</code>. I wish to remove those empty characters during string comparison. I tried using <code>replace</code> and <code>trim</code> but that didn't help me, the only thing that did work was using <code>LIKE</code>, but that is not safe. </p>
  
  <p>So my question is, how can I remove unwanted "00" characters from the string I fetch from a table?</p>