Does anyone have a creative way to match last names in instances when a person keeps their maiden name and appends their new last name?
For example, let's say MARY JONES gets married and changes her name to MARY SMITH JONES OR MARY SMITH-JONES. I need to match "SMITH JONES" or "SMITH-JONES" to her maiden name "JONES" which we have on file. Is there a way to match only the LAST characters in strings?
Matching on appended married names
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: