title: Convert binary to uniqueidentifier in t-sql?
body: <p>I have the following code that converts Unique-identifier to Binary:</p>
  
  <pre><code>CAST(GUID AS BINARY(16))
  </code></pre>
  
  <p>which results in this <code>'0x56B3C0955919CD40931F550749A83AF3'</code></p>
  
  <p>Now, I want to convert this (i.e. the <strong>binary string value</strong> <code>'0x56B3C0955919CD40931F550749A83AF3'</code>) to Unique-Identifier.</p>
  
  <p>Any simple way to achieve this?</p>