declare @LogonPass varchar(100)='1234' set @LogonPass = substring(sys.fn_sqlvarbasetostr(hashbytes('MD5',@LogonPass)),3,32) select @LogonPass -- e10adc3949ba59abbe56e057f20f883e