title: How to set a hash in a variable?
body: <p>I am trying to encrypt the result of this query in variable, the point
  is that I am not getting the hash but a strange string of symbols</p>
  <pre><code>ALTER PROCEDURE [dbo].[EncriptDesEncriptPassword] (
      @pUsuario CHAR(15), 
      @pContraseña AS VARCHAR(10),
  )
  AS
  BEGIN    
      DECLARE @ContraseñaHash varchar(70),
      @passwordHash varchar(70);
  
     SELECT @ContraseñaHash = HASHBYTES ('SHA2_256', @pContraseña) FROM UsersApp2 WHERE Usuario= @pUsuario
  </code></pre>
  <p>The expected result:<br />
  <code>0xFEED6896B729BF4A2EA5396FF3EFCB99CEB2187CA825AC8B9598D3819D1142A5</code></p>
  <p>What I am getting:<br />
  <code>þíh–·)¿J.¥9oóïË™Î²|¨%¬‹•˜ÓB¥</code></p>