title: Select Hex/Char conversion
body: <p>I have some data in a SQL database stored in the format below, which I would like to convert to a readable string: </p>
  
  <pre><code>540045005300540049004E00470031003200330034
  </code></pre>
  
  <p>I would like to run some kind of SELECT statement to return the text which should be <code>TESTING1234</code></p>
  
  <p>It appears to be in Hex format separated by 00 between each character, so if I run these statements:</p>
  
  <pre><code>SELECT CHAR(0x54)
  SELECT CHAR(0x45)
  </code></pre>
  
  <p>This returns:</p>
  
  <pre><code>T
  E
  </code></pre>
  
  <p>Is there any way I can convert the whole string in one statement?</p>
  
  <p>Thanks!</p>