better name match checking

Results 1 to 2 of 2

Thread: better name match checking

  1. #1
    sunny Guest

    Default better name match checking

    I am setting up a name match checking module. It has a text box where a user can enter a first name, then a last name, and a SQL stmt will return all entries LIKE what the user entered. Here is the issue. If a user enters Bill, I need something that will check for William as well as Bill. Same for James, checking for Jim, same for Thomas checking for Tom, etc. Is there anything out there already written for this? Any ideas?

  2. #2
    Eddie Campbell Guest

    Default RE: better name match checking

    The only way I can think of is to build a table of "Nicknames". When the user searches for Bill or Will, the table would find the record and return the Id to the person name William.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts