title: Convert GUID to varchar(32)
body: <p>How can I convert a GUID which is <code>36</code> characters to a VARCHAR(32)?</p>
  
  <p>I'm trying to copy data from one table to another. There are two similar columns from these two tables.</p>
  
  <ol>
  <li><strong>Table1.colx</strong> is a GUID so it is <code>36</code> characters in length in total due to the hyphens</li>
  <li>The corresponding column is <strong>table2.colx</strong> but it is a VARCHAR(32) </li>
  </ol>
  
  <p>I am looking for a way to convert a GUID to VARCHAR, but I've got to remove the hyphens.  So far I have been unsuccessful in my attempts to find a way to do this.</p>