[AccessD] Hash - was: First in a group

John, thanks for - as usual - an elaborate response to a 
qustion  - I can put this to good use.

Also thanks to Max for asking and Gustav for providing the 
MD5 hash algoritm for VBA!

Regards
Borge

---- Original message ----
>Date: Thu, 13 Sep 2007 23:58:00 -0400
>From: "jwcolby" <jwcolby at colbyconsulting.com>  
>Subject: Re: [AccessD] First in a group  
>To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
>
>Borge,
>
>The hash was done in SQL Server.  There is a Hash function 
inside of SQL
>Server that I used.  It has various "brands" of hash and I 
chose one (sha1),
>then just ran all of the address fields into the hash 
function and out pops
>a binary (~160 bit?) hash number.
>
>UPDATE [PSM_DPSI11000].[dbo].[tblData]
>   SET [HashAddr] = hashbytes('sha1', Addr + Zip5 + Zip4)
>      ,[HashFamily] = hashbytes('sha1', Addr + Zip5 + Zip4 
+ LName)
>      ,[HashPerson] = hashbytes('sha1', Addr + Zip5 + Zip4 
+ LName + FName)
>
>Google HashBytes for more info on that function.
>