DSXchange

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?

Are you using QualityStage? Are you able to use QualityStage?

[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

Off we go!

You could use REVERSE string, you could match the rightmost characters, you could generate Reverse Soundex.

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