Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2011
    Posts
    2

    Unanswered: partial match in a record field

    hello guys,
    I have a table with ID, CompanyName and flag fields, having 4000 records. Some of these records have the same company name, but with in different formats, example:
    "Europe African Bank" similar to "Bank of Europe Africa"

    What I am looking for is a Query or a Stored Procedure to find the records with a possible match and place "1" in the flag field. The process should not be 100% accurate, as the flag field will be used for a later human processing. Any idea what can I do ??

    Thx

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Try this function I wrote, and have tested extensively, to perform fuzzy searching:
    http://dl.dropbox.com/u/2507186/Func...ompareText.sql
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Nov 2004
    Posts
    1,427
    Provided Answers: 4
    Quote Originally Posted by blindman View Post
    Try this function I wrote, and have tested extensively, to perform fuzzy searching:
    http://dl.dropbox.com/u/2507186/Func...ompareText.sql
    Blindman,

    I keep receiving timeouts.
    With kind regards . . . . . SQL Server 2000/2005/2012
    Wim

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    How big is your datafile? I've never gotten time-outs with that.
    Post some sample data that you are trying to compare. Two strings, for example.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  5. #5
    Join Date
    Nov 2004
    Posts
    1,427
    Provided Answers: 4
    I meant, I kept receiving time outs when I clicked the URL. But now it works.
    With kind regards . . . . . SQL Server 2000/2005/2012
    Wim

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

  6. #6
    Join Date
    Aug 2011
    Posts
    2
    thx blindman that was totally helpful

Tags for this Thread

Posting Permissions

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