Looks up all accounts set to use the given email address by comparing email hashes.
Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation
-- 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