How do you determine what size to make your VARBINARY field to hold the results of the HASHBYTES function?
Is it simply a matter of setting it to be equal to the largest HashByte function input value?
DECLARE @vHashResults AS VARBINARY(40)
DECLARE @vHashInput01 AS CHAR(20)
DECLARE @vHashInput02 AS CHAR(20)
SET @vHashInput01 = 'thisisa20bytechar123'
SET @vHashInput02 = 'thisisa21bytechar1234'
SET @vHashResults = HashBytes('SHA1', @vHashInput01 + @vHashInput02)
Data Enthusiast | @SQLbyoBI | www.opifexsolutions.com