title: Cleaning SQL Data
body: <p>What is causing the two fields to be different ?  Is it a tab or something else ?  What is an easy way to clean it ?  I know I can somehow use replace, but I am unsure of what I am replacing and there are many more records with the same problem.</p>
  
  <pre><code>Name    Binary
  MCMPAD  0x4D0043004D00500041004400200020
  MCMPAD  0x4D0043004D00500041004400A00020
  
  
  SELECT  Name , convert(binary(15), (Name))  Binary from VirtualTerminal
  where Name  like '%MCMPAD%'
  </code></pre>