Name table

  • Hello, My search skills are poor at best, so I was not able to get very far. But I have a nice table of measurement conversions.

    What I want is a table of common names so for a given name it will be matched to a standard name.

      [font="Courier New"]Name Standard

      ------ -------

      Bill William

      Rich Richard

      Tony Anthony[/font]

    Has anyone heard of something like this?

    Thank you,

  • If you're looking for a list of names, Google: "nicknames and full names" and you'll find a few.

    What you're trying to do is a simple use of a lookup table. It's a commonly used process, but maybe not for names.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • Lookup table no problem. Been there done that.

    I was looking for information to populate the lookup table.

    Thanks for the nickname hint. One problem I have with internet searches is I tend to focus too tightly.

  • bear in mind that this is a many to many relashionship - in many cases but not all this will be resolved providing you know the sex of the individual.

    e.g. Al could be Alexander, Alistair (and variants), Alan (and variants), Alfred, Alice, Allyssa, Alison

  • crmitchell (7/30/2014)


    bear in mind that this is a many to many relashionship - in many cases but not all this will be resolved providing you know the sex of the individual.

    e.g. Al could be Alexander, Alistair (and variants), Alan (and variants), Alfred, Alice, Allyssa, Alison

    Thanks. This is just a check used for a fuzzy match of first name after SSN and last name are matched.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply