title: Cast a Hex String to varbinary in SQL Server
body: <p>Let say I have a <code>varchar(100)</code> call <code>@hexString</code> and I</p>
  
  <pre><code>SET @hexString ='0x47617279204a6f686e736f6e2032303230'
  </code></pre>
  
  <p>How do I cast this varchar to an actual hexidecimal <code>0x47617279204a6f686e736f6e2032303230</code>(without the quotation mark)?</p>