How to convert Hasbytes to varchar ? I came across this question recently when I was working on my previous article. Then I started with my research to develop a solution.
Given below is the script that can convert Hashbytes to Varchar :
DECLARE @varchar varchar(Max);
DECLARE @hashbytes varbinary(20)
-- Convert 'raresql' string into Hasbytes
SET @hashbytes=HASHBYTES('SHA1','raresql');
-- Select Hasbytes value
Select @hashbytes as Hasbytes
--Convert varbinary value to varchar value
Set @varchar='0x' + cast('' as xml).value
('xs:hexBinary(sql:variable("@hashbytes"))', 'varchar(max)');
--Select varchar value
Select @varchar as [Varchar]
SQL Server Portal 