title: Updating a database column based on its similarity to another database column
body: <p>I have a database table (Customers) with the following columns:</p>
  
  <pre><code>ID
  FIRST_NAME
  MIDDLE_INIT
  LAST_NAME
  FULL_NAME
  </code></pre>
  
  <p>I also have a database table (ENG) with the following columns:</p>
  
  <pre><code>ID
  ENG_NAME
  </code></pre>
  
  <p>I want to replace all of the <code>ENG.ENG_NAME</code> entries with a <code>FULL_NAME</code> entry from the <code>CUSTOMERS</code> table</p>
  
  <p>Here is the problem.<br>
  The <code>ENG_NAME</code> was hand-jammed through a web form and, so, has no consistency.  For instance, one row might contain "Robin Hood".  Another "Hood, Robin L".  An another "Robin L Hood".</p>
  
  <p>I want to search the entries in the <code>CUSTOMERS</code> table, find a close match, then replace the <code>ENG.ENG_NAME</code> with the <code>CUSTOMERS.FULL_NAME</code>.</p>
  
  <p>Example:</p>
  
  <pre><code>ENG table              CUSTOMERS table          
  ID      ENG_NAME       ID      FULL_NAME        FIRST_NAME     MIDDLE_INIT      LAST_NAME
  ================       ==================================================================        
  1       Hood,Robin     1       Robin L Hood     Robin          L                Hood
  2       Rob Hood       2       Maid M Marion    Maid           M                Marion
  3       Marion M       3       Friar F Tuck     Friar          F                Tuck
  4       Rob Garza      4       Robert A Garza   Robert         A                Garza
  </code></pre>
  
  <p>Based on the data above, I would want <code>ENG_NAME</code> columns to be replaced like this:</p>
  
  <pre><code>ENG table
  ID      ENG_NAME
  ====================
  1       Robin L Hood
  2       Robin L Hood
  3       Maid M Marion
  4       Robert A Garza
  </code></pre>
  
  <p>Any thoughts on how to do this?
  Thanks</p>