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]