From: esquel@sommarskog.se   
      
   Shelly (sheldonlg@thevillages.net) writes:   
   > Anyway, I have the solution.  It is to enclose the HASHBYTES stuff with   
   > the following:   
   >   
   > SUBSTRING(master.dbo.fn_varbintohexstr(  hashbytes calculation ), 3, 32).   
   >   
   > The result is a 32 character hex string put into the tracking table.   
   >   
      
   If you are on SQL 2008, use   
      
     convert(varchar(32), hashbytes, 2)   
      
   instead, as this is a documented and supported way to get a hex string.   
      
      
   --   
   Erland Sommarskog, Stockholm, esquel@sommarskog.se   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)