title: DECRYPTBYASYMKEY() Not Returning Expected Value
body: <p>I'm playing around with <a href="http://msdn.microsoft.com/en-us/library/ms173744.aspx" rel="nofollow">Asymmetric Encryption and Decryption</a>, but I don't understand the results I'm getting when I try to decrypt values.</p>
  
  <p>Why does this:</p>
  
  <pre><code>CREATE ASYMMETRIC KEY myasymkey 
      WITH ALGORITHM = RSA_2048 
      ENCRYPTION BY PASSWORD = '123pass!'; 
  GO
  
  SELECT DECRYPTBYASYMKEY(ASYMKEY_ID('myasymkey'), 
      EncryptByAsymKey(AsymKey_ID('myasymkey'), 'Greg'), 
      N'123pass!');
  GO
  </code></pre>
  
  <p>Produce <code>0x47726567</code>? I was expecting it to be <code>Greg</code>.</p>
  
  <p><strong>UPDATE:</strong> I'm dumb, <code>0x47726567</code> is <code>Greg</code> when converted from <code>varbinary</code>.</p>