Hi, I am wondering if anyone knows if it is possible to create a MS-SQL analog of the following Oracle function ... which provides hasing of SSN and DOB:
I am hoping Dan Connolly might be able to provide direction. The fallback is to create a python script to interface to MS-SQL and create hashed versions of DOB and SSN. Oracle code: """ create function dmf.keyed_hash(data varchar2, hash_key varchar2) return varchar2 is begin return DBMS_CRYPTO.mac( UTL_I18N.string_to_raw(data, 'AL32UTF8'), DBMS_CRYPTO.hmac_sh1, UTL_I18N.string_to_raw(hash_key, 'AL32UTF8')) end """ Jay Pedersen, M.A. Department of Pathology/Microbiology University of Nebraska Medical Center 985900 Nebraska Medical Center Omaha NE 68198-5900 402-559-9487<tel:402-559-9593> (office) 402-739-3496<tel:402-350-7851> (mobile) The information in this e-mail may be privileged and confidential, intended only for the use of the addressee(s) above. Any unauthorized use or disclosure of this information is prohibited. If you have received this e-mail by mistake, please delete it and immediately contact the sender.
_______________________________________________ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev
