Looks up all accounts set to use the given email address by comparing email hashes.
Q&A about the site for expert genealogists and people interested in genealogy or family history
-- Find a user by email address -- Looks up all accounts set to use the given email address by comparing email hashes. declare @hash varchar(32) = substring(master.dbo.fn_varbintohexstr( hashbytes('md5', lower(ltrim(rtrim('##EmailAddress##')))) ), 3, 32) select Id as [User Link] from Users where EmailHash = @hash