I would be interested in hearing from anyone who has developed logic for identifying patients that have more than one Medical Record Number. There are obvious easy matches to make such as birthdate and gender. However, once you start looking a names and addresses, the possibility of mis-spelling arises. We are particularly interested in an SQL Server solution, but an NPR solution would be acceptable as well. Thomas Stephen Laxar Coordinator, Hospital Information Systems Children's Hospital Oakland 510-428-3833 [EMAIL PROTECTED] The email message (and any attachments) is for the sole use of the intended recipient(s) and may contain confidential information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message (and any attachments). =*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*= To subscribe or unsubscribe to the meditech-l, visit MTUsers.NET.
To check the status of the meditech-l, visit MTUsers.NET. For help, email [EMAIL PROTECTED] Visit the MTUsers WikiPedia at MTUsers.NET/mwiki ______________________________________ meditech-l mailing list meditech-l@MTUsers.com http://mtusers.com/mailman/listinfo/meditech-l