Matching on appended married names

Infosphere's Quality Product

Moderators: chulett, rschirm

Post Reply
pk7
Participant
Posts: 44
Joined: Fri Aug 03, 2007 8:35 am
Location: Kansas CIty

Matching on appended married names

Post by pk7 »

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?
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Are you using QualityStage? Are you able to use QualityStage?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
pk7
Participant
Posts: 44
Joined: Fri Aug 03, 2007 8:35 am
Location: Kansas CIty

Post by pk7 »

[Ray,

Yes, I am. Sorry, I should have mentioned that. I know that I can use NAME_UNCERT if I was matching "SMITH JONES" to "SMITH" but how would I match "SMITH JONES" to "JONES"?

Thanks!

Glenn
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Off we go!
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

You could use REVERSE string, you could match the rightmost characters, you could generate Reverse Soundex.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
pk7
Participant
Posts: 44
Joined: Fri Aug 03, 2007 8:35 am
Location: Kansas CIty

Post by pk7 »

Thanks Ray but...

- what is REVERSE string? Is that a DS function? I can't find that one.
- how do I match rightmost characters with QS? That's exactly what I want to do but don't see a way to do that.

Glenn
Post Reply